Programmatically open / edit vba-editor

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
 
Joined
Aug 7, 2015
Messages
1
Reaction score
0
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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top