Q: Open VB - Editor from macro...?
 

is it possible to open the Vb editor from a Macro..?
Andrew

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
|
|

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

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
|
|
|
|