Programmatically open / edit vba-editor

  • Thread starter Thread starter hglamy
  • Start date Start date
H

hglamy

Hello there,

can the vba-editor be opened programmatically,
i. e. on the start of Excel and / or can a module
receive codetext programmatically ?

Thank you in advance,

H.G. Lamy
 
This is a few years late, but in case people try to search, I have found a successful way to open VBA in Excel Programmatically from a userform.

Private Sub CommandButton8_Click()
'Open VBA

'Allow for sheet to take active window
UserForm1.Hide

'Makes Workbook active over Userform, this will enable Alt+F11 to function
Worksheets("Sheet1").Range("A1").Select

'Run Alt+F11
Application.SendKeys "%{F11}", True

End Sub

hglamy said:
Hello there,

can the vba-editor be opened programmatically,
i. e. on the start of Excel and / or can a module
receive codetext programmatically ?

Thank you in advance,

H.G. Lamy
Click to expand...
 
Back
Top