Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    ASKER, Norway
    Posts
    277
    Thanks
    6
    Thanked 0 Times in 0 Posts

    VBA Editor (Wind 2000, Office XP)

    I am trying to get the VBA Editor to dock the Project Explorer and Project Properties windows to one of the sides in the VBA window by marking the various windows dockable in Tools/Options, but my VBA Editor will not dock the various windows.

    I used have this nicely set up, but after I rezied a window it suddenly turned out of my control.

    Is there any setting I have missed?

    Bjorn

  2. #2
    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: VBA Editor (Wind 2000, Office XP)

    A couple years ago I managed to really mess up my VBE. Somehow I managed to reset it to the factory spec and then was able to adjust from there. I don't remember how I did that... but that is what I would suggest doing.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    This is a problem in Office 2000 (I think that it is a bug). I wrote a post describing how to recover from this back in March of 2001 which was made a Star Post. Unfortunately, the post has been lost because of the lounge's server resource problems. I no longer have the post, but will try to remember how to do this. The procedure below assumes that you want the windows on the left of the VBE window where they would be by default.

    First, select the window that you want to end up on the bottom. Now, put the cursor at the right edge of the title bar, left click, and drag the window slowly to the left edge of the VBE window until the window outline changes into a long vertical outline (this will probably occur when the outline is about half off the screen. Release the mouse button to drop the window. The window should now be docked at the left edge of the screen.

    Second, Select the other window, and again put the cursor at the right end of the title bar, left click and drag slowly until the window outline becomes a long verticle outline. Drop the window. The two windows will now probably be docked side by side.

    Third, put the cursor at the right side of the title bar of the second window, left click and drag slowly to the left until the outline again changes to a verticle outline. Drop the window again. The two windows should now be docked one on top of the other with the second one very small at the bottom of the screen.

    Fourth, move the cursor between the two windows until it changed into a double arrow pointing up and down. Drag until you get the windows the size that you want them.
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    ASKER, Norway
    Posts
    277
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    Thanks a lot Legare!

    I got it working eventually. It was difficult the second step; to get the two bars on top of each other. I had to drop it while on top of the first one, not bringing it to the far left end when it again became a vertical bar.

    Thanks again,
    Life is much more easier now!

    Bjorn

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Brussels, Brussel, Belgium
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    for reference, i retrieved the star post from my personal archives

    ==============================================
    Subject: Docking Floating Windows in VBE Editor [#19683]
    Poster: LegareColeman
    Posted on: 01/03/02 02:00

    I just undocked my Project Explorer and Properties windows, and I had the same problem. However, I was finally able to get them redocked where they are supposed to be. I did it by right clicking on the window and then clicking on the Dockable command on the pop up menu. This caused the window to dock to the top of the VBE window, across the complete width of the window. I then grabbed the top right of the title bar, just to the left of the close window X and dragged to to lower left of the VBE window until the drab box changed to a smaller box and released. The window then docked on the left side where I wanted it. I did the same thing with both windows and got them back where they belong.

    Legare Coleman
    ==============================================

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    Thanks. That was the post.
    Legare Coleman

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    My fat fingers have done the same thing.

    Mt recollection is that I just reset the Dock key in.

    [HKEY_CURRENT_USERSoftwareMicrosoftVBA6.0Common]

    If yiu want to try this, first back up the key before modifying th eregistry.

  8. #8
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Editor (Wind 2000, Office XP)

    If you accidentally undock one of the windows, the quickest way to redock it is to double click the titlebar of the undocked window.

    The double click will redock it in the last spot it was docked in.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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