Run Visual Basic after starting Excel.

[rediffusion]

I find this code on site.

Private Sub Workbook_Open()
    UserForm1.Show
End Sub

It's not working.
I want to open «Visual Basic» after starting «Excel» then open the window 'Module1' for example. Is it feasible?

 

[footoo]

Have you put the macro in the ThisWorkbook module?

To automatically open the VBE and Module 1 when the workbook is opened, you need at least one macro in Module 1 (let's say named MyMacro) :

Private Sub Workbook_Open()
UserForm1.Show


On Error Resume Next
Application.Goto Reference:="MyMacro"
If Error <> 0 Then _
    Application.VBE.MainWindow.Visible = True
Application.Goto Reference:="MyMacro"
End Sub

 

[Fluff]

Cross posted https://www.excelguru.ca/forums/showthread.php?10078-Run-Visual-Basic-after-starting-Excel

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[rediffusion]

footoo

This is not what i want, but thx anyway!
Here i find solution it's really helps me.