VBA Editor - Open Windows 
Author Message
 VBA Editor - Open Windows

Greetings, all.  I've been using VBA to build solutions
with Access and Excel now for a good couple of years (I
know, seasoned veteran, right!), but there's something
I've noticed about the VBA Editor that has me puzzled:

Each time I open a project file and hit Alt-F11 to get to
familiar territory, the number of windows and which
windows open in the editor seem to be entirely random.  
This is nothing more than an annoyance really, unless I've
got 4 or 5 other RAM-heavy app's open and the Editor
decides to open with 12 windows.  I just have to remember
to go through and close, one by one, all the windows I
don't need each time I open it.

Do we have any control over which modules (windows) open
when the editor opens, or is it really random as it seems?

Thanks and G'day! (I'm not Australian but I've always
wanted to visit)



Tue, 03 Aug 2004 00:57:14 GMT  
 VBA Editor - Open Windows
Keep a simple password on your VBA project to stop this.

--
David Hager
Excel MVP
Baton Rouge, La.


Quote:
>Greetings, all.  I've been using VBA to build solutions
>with Access and Excel now for a good couple of years (I
>know, seasoned veteran, right!), but there's something
>I've noticed about the VBA Editor that has me puzzled:

>Each time I open a project file and hit Alt-F11 to get to
>familiar territory, the number of windows and which
>windows open in the editor seem to be entirely random.
>This is nothing more than an annoyance really, unless I've
>got 4 or 5 other RAM-heavy app's open and the Editor
>decides to open with 12 windows.  I just have to remember
>to go through and close, one by one, all the windows I
>don't need each time I open it.

>Do we have any control over which modules (windows) open
>when the editor opens, or is it really random as it seems?

>Thanks and G'day! (I'm not Australian but I've always
>wanted to visit)



Tue, 03 Aug 2004 05:49:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Word won't open VBA editor

2. Cannot open the VBA editor from outlook XP !

3. can't open a project in the VBA editor

4. Cannot open Project in VBA Editor: Project Locked

5. Word won't open VBA editor

6. outlook forms script editor - execute VBA editor modules

7. Visual Basic Editor/Macro Editor don't open

8. Adding VBA function to Visio's VBA Editor from ActiveX DLL

9. MS Word VBA: Looping through opened Windows

10. MS Word VBA: Looping through opened Windows

11. MS Word VBA: Looping through opened Windows

12. List of Open Windows in VBA

 

 
Powered by phpBB® Forum Software