#1
|
|||
|
|||
too many windows in the VBA editor
I recently bought a new computer on which I have Windows 7 and Office 2010 installed. My problem is that when I edit a Word macro in the VBA editor, finish my editing, and close the VBA editor, that macro window is still open the next time I open the VBA editor to edit a different macro. Thus, for example, suppose I open the VBA editor to edit Macro A. I finish my work and close the editor. Later I open the VBA editor to edit Macro B. I finish this work and close the editor. Later still I open the VBA editor to edit Macro C. At this point, I find that the windows for editing Macros A and B are still open. I find that I have to explicitly close a window before closing the VBA editor in order to prevent it from being reopened when I reopen the VBA editor. Is there any way to change the default behavior of the VBA editor such that when I close the editor, I also set the editor so that windows will not reopen automatically when I reopen the editor? |
#2
|
||||
|
||||
The VBE functions rather like Word itself, with windows for the code modules in each of the currently-open documents. If you don't want to see the code modules for a document, close the document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I didn't realize that the separate windows were associated with macros in different modules. So am I right in thinking that (a) the VBA editor will never display two different windows that contain different macros from the same module? but (b) if the user decides to edit macro A in module_1 and, later in the same session, to edit macro B in module_2, the vba editor windows for module_1 and module_2 will both remain open unless the user explicitly closes one of these windows?
|
#4
|
||||
|
||||
Re. (a): Unless you regard a split window as two different windows, correct.
Re. (b): Correct. Closing a document explicitly closes its window(s).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thank you - now I get it.
|
Tags |
vba editor windows |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert Ofc 2000/Windows XP OS docs to Windows 7 OS which has NO Ofc Version Loaded | mylittleturbott | Office | 2 | 03-17-2014 03:18 PM |
Scan and edit doc in windows using Office 2000 on Windows 8 | karenhaas | Word | 3 | 01-29-2014 12:23 PM |
Does the Office 2013 interface look different in Windows 7 vs Windows 8? | tamijsmith | Office | 2 | 12-17-2013 01:55 PM |
where is microsoft script editor for office 2013 in windows 8? | automate_office | Office | 1 | 10-14-2013 04:47 PM |
Photo Editor is Gone!!! | obenix | Office | 2 | 06-07-2005 07:45 AM |