Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBE Windowing Behavior (Excel 2000, SR1)

    Hi Folks,

    The VBE for Office 2000 has a "convenience" that is very annoying for me, which is: any time I open the VBE from a fresh Excel session, the Windows menu is populated with three windows, one from PERSONAL.XLS and two others from a custom Add-In I created.

    Since I am almost never interested in editing either of these, I would rather VBE begin with an empty MDI and with everything in the Project Explorer collapsed except the VBAProject for the active workbook. At which point, I would proceed to add modules or UserForms or whatever. Instead, I have to close a bunch of windows I never ever care anything about.

    Is there any way to change this behavior? I searched the registry to try to find a history for the Windows menu item (so maybe I could clear the history), but to no avail. I also searched the hard drive for any files that might store the VBE settings from session-to-session, to no avail.

    Any suggestions? Thanks!

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: VBE Windowing Behavior (Excel 2000, SR1)

    Jim,

    have you tried just closing all thos windows and closing the VBE, as that should then be the default on starting any future sessions.

    I'm not sure if <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=vb&Number=19683&Search= true&Forum=vb&Words=&Match=StarPost&Searchpage=0&L imit=25&Old=allposts&Main=19547>This Post</A> from Legare on Docking windows is of any help, but worth looking at anyway.

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBE Windowing Behavior (Excel 2000, SR1)

    Hi Andrew,

    That is tried by default, since the first thing I do every time I use the VBE is close those windows; I do not re-open them before closnig the VBE. Despite this, the windows always open upon opening VBE.

    Thanks.

  4. #4
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: VBE Windowing Behavior (Excel 2000, SR1)

    Jim,

    I had much the same problem with Word 97 - at that time I was using Normal.dot as a kind of code scratchpad so had a lot of modules in there.
    Every time I launched Word and went to the VBE, all of the code windows were open. The cause for this was never tracked down; about the best I could do was write a macro that closed all the windows.
    The problem went away when I moved to Word 2000.

    One thing I didn't try at the time, perhaps might be worth trying, would be to delete the Registry key for the VBE(?)

    Gary

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBE Windowing Behavior (Excel 2000, SR1)

    Yeah... similar thoughts, none of which are very savory, went through my head. Early on, I tried identifying any useful information in the registry, but wasn't successful - any idea what the right items might be?

    Thanks.

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VBE Windowing Behavior (Excel 2000, SR1)

    Maybe the state of VBE windows is saved in Normal.dot/Personal.xls itself? If you dirty a module, close all the windows, and save from inside the VBE, then shut down Word/Excel and restart and check... does that help?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •