View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.