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

A

Andrew

Never mind..! Just put a "stop" statement in first line of
Private Sub Workbook_Open()
Thanx Anyway
Andrew

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

Andrew

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


| Hi Andrew
|
| You can use
|
| Application.VBE.MainWindow.Visible = True
|
|
| --
| Regards Ron de Bruin
|
|
|
| > is it possible to open the Vb editor from a Macro..?
| > Andrew
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically Halt Macro and Open VB Editor 2
Opening the VB Editor via VB 5
Disabled VB Editor Button and Macro Buttons 4
VB Editor Window 2
VB Editor Window 6
Visual Basic Editor Opening and Closing for User 14
Computer lock opens VB editor 2
Does the Macro Editor have an .exe associated to it? 3

Top