View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_7_] Peter T[_7_] is offline
external usenet poster
 
Posts: 162
Default Error in VB Editor Coding


"GS" wrote in message

It's not really to select windows but to close them. I run it from a
button on the VBE menu and it gets clicked often. Also before saving to
avoid windows opening when the file next loads.

Peter T


I took a look at that in v2010 and see it has a menuitem 'Close All
Windows' at the bottom.

Is this what y'all are talking about?
What does it matter how many windows are open?
(There appears to be a limit to the length of the list
*and* a 'More Windows...' option that displays more windows in
a listbox of a popup window!)

This is what I also find in v2003.


I guessed that was MZ Tools :)

I have my own menuitem in the same place, it does similar but also collapses
folders in Project Explorer.

It's about convenience rather than "matter". Easier to keep only the windows
you're working with open if navigating say with say ctrl-tab or even form
the Windows dropdown. Also when a file opens that had been saved with open
modules/windows, it can take a while to open the same windows again next
time it opens. IOW it reopens with windows in the same state as saved.

Peter T






 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.