Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2014, 07:53 PM
floattube floattube is offline too many windows in the VBA editor Windows 7 64bit too many windows in the VBA editor Office 2010 64bit
Novice
too many windows in the VBA editor
 
Join Date: May 2014
Location: Seattle
Posts: 4
floattube is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 11-26-2014, 09:00 PM
macropod's Avatar
macropod macropod is offline too many windows in the VBA editor Windows 7 64bit too many windows in the VBA editor Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 11-27-2014, 12:07 AM
floattube floattube is offline too many windows in the VBA editor Windows 7 64bit too many windows in the VBA editor Office 2010 64bit
Novice
too many windows in the VBA editor
 
Join Date: May 2014
Location: Seattle
Posts: 4
floattube is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 11-27-2014, 12:15 AM
macropod's Avatar
macropod macropod is offline too many windows in the VBA editor Windows 7 64bit too many windows in the VBA editor Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 11-27-2014, 01:33 AM
floattube floattube is offline too many windows in the VBA editor Windows 7 64bit too many windows in the VBA editor Office 2010 64bit
Novice
too many windows in the VBA editor
 
Join Date: May 2014
Location: Seattle
Posts: 4
floattube is on a distinguished road
Default

Thank you - now I get it.
Reply With Quote
Reply

Tags
vba editor windows

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
too many windows in the VBA editor 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
too many windows in the VBA editor Scan and edit doc in windows using Office 2000 on Windows 8 karenhaas Word 3 01-29-2014 12:23 PM
too many windows in the VBA editor Does the Office 2013 interface look different in Windows 7 vs Windows 8? tamijsmith Office 2 12-17-2013 01:55 PM
too many windows in the VBA editor where is microsoft script editor for office 2013 in windows 8? automate_office Office 1 10-14-2013 04:47 PM
too many windows in the VBA editor Photo Editor is Gone!!! obenix Office 2 06-07-2005 07:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft