Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109046

Re: Error in VB Editor Coding

From "Peter T" <askformy@gmail.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Error in VB Editor Coding
Date 2016-07-04 11:31 +0100
Organization A noiseless patient Spider
Message-ID <nlddtc$mh2$1@dont-email.me> (permalink)
References (3 earlier) <nl9fpd$gqm$1@dont-email.me> <nla39k$1j7$1@dont-email.me> <nla3ir$26g$1@dont-email.me> <nlbctb$p85$1@dont-email.me> <nlbmom$s4f$1@dont-email.me>

Show all headers | View raw

"GS" <gs@v.invalid> 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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Error in VB Editor Coding Tim Childs <tsnip1NOTTHIS@yahoo.co.uk> - 2016-06-30 20:50 +0100
  Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-06-30 19:44 -0400
  Re: Error in VB Editor Coding Mike S <mscir@yahoo.com> - 2016-06-30 17:41 -0700
  Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-01 19:01 +0100
    Re: Error in VB Editor Coding Tim Childs <tsnip1NOTTHIS@yahoo.co.uk> - 2016-07-02 18:48 +0100
      Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-02 18:38 -0400
        Re: Error in VB Editor Coding Tim Childs <tsnip1IgnoreThis@yahoo.co.uk> - 2016-07-03 05:11 +0100
          Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-03 00:16 -0400
            Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-03 17:02 +0100
              Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-03 14:49 -0400
                Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-03 16:38 -0400
                Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-04 11:31 +0100
                Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-04 06:39 -0400
                Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-04 06:41 -0400
                Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-04 12:18 +0100
                Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-04 07:23 -0400
                Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-04 12:49 +0100
                Re: Error in VB Editor Coding GS <gs@v.invalid> - 2016-07-04 09:20 -0400
      Re: Error in VB Editor Coding "Peter T" <askformy@gmail.com> - 2016-07-03 16:37 +0100
        Re: Error in VB Editor Coding Tim Childs <tsnip1NOTTHIS@yahoo.co.uk> - 2016-07-03 22:02 +0100

csiph-web