
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)