Programmatically open / edit vba-editor

[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

 

[Ron de Bruin]

Hi

Application.VBE.MainWindow.Visible = True

See http://www.cpearson.com/excel/vbe.htm
For the other part in your thread