Macro Question/CHRIS
 

I'd like to create a macro that will launch VBE. Instead
of using ALT+F11, I'd like a button on the toolbar. When
I record in Excel the ALT+F11 keystroke, no code is
produced.

Any ideas?

Thanks.

Macro Question/CHRIS
 

Try

Application.VBE.MainWindow.Visible = True


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



"chris" wrote in message ...
I'd like to create a macro that will launch VBE. Instead
of using ALT+F11, I'd like a button on the toolbar. When
I record in Excel the ALT+F11 keystroke, no code is
produced.

Any ideas?

Thanks.

Macro Question/CHRIS
 

There is such a button on the Visual Basic toolbar

HTH
Anders SIlvén

"chris" skrev i meddelandet
...
I'd like to create a macro that will launch VBE. Instead
of using ALT+F11, I'd like a button on the toolbar. When
I record in Excel the ALT+F11 keystroke, no code is
produced.

Any ideas?

Thanks.