| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: Open VB - Editor from macro...?
is it possible to open the Vb editor from a Macro..?
Andrew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open VB - Editor from macro...?
Hi Andrew
You can use Application.VBE.MainWindow.Visible = True -- Regards Ron de Bruin http://www.rondebruin.nl "Andrew" <NoToSPAM@home wrote in message ... is it possible to open the Vb editor from a Macro..? Andrew |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open VB - Editor from macro...?
Thanx Ron.
Will investigete the whole VBE object, Didnt know it even exist. P.S. Your Web Pages have some really helpful and handy stuff. Thanx again Ron. http://www.rondebruin.nl "Ron de Bruin" wrote in message ... | Hi Andrew | | You can use | | Application.VBE.MainWindow.Visible = True | | | -- | Regards Ron de Bruin | | | | "Andrew" <NoToSPAM@home wrote in message ... | is it possible to open the Vb editor from a Macro..? | Andrew | | | | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open VB - Editor from macro...?
Never mind..! Just put a "stop" statement in first line of
Private Sub Workbook_Open() Thanx Anyway Andrew "Andrew" <NoToSPAM@home wrote in message ... | is it possible to open the Vb editor from a Macro..? | Andrew | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro editor problem | Excel Discussion (Misc queries) | |||
| Hyperlink .jpg now open in IE not Photo Editor like before IE upgr | Excel Discussion (Misc queries) | |||
| Don't open vb editor | Excel Discussion (Misc queries) | |||
| Macro editor passwords | Excel Programming | |||
| Programmatically open / edit vba-editor | Excel Programming | |||
Hybrid Mode
