![]() |
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
![]() |
mylittleturbott | Office | 2 | 03-17-2014 03:18 PM |
![]() |
karenhaas | Word | 3 | 01-29-2014 12:23 PM |
![]() |
tamijsmith | Office | 2 | 12-17-2013 01:55 PM |
![]() |
automate_office | Office | 1 | 10-14-2013 04:47 PM |
![]() |
obenix | Office | 2 | 06-07-2005 07:45 AM |