Programmatically open / edit vba-editor
 

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

Programmatically open / edit vba-editor
 

Hi

Application.VBE.MainWindow.Visible = True

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"hglamy" wrote in message ...
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