+ Reply to Thread
Results 1 to 4 of 4

Resetting to original window position in editor

  1. #1
    Registered User
    Join Date
    08-17-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    35

    Resetting to original window position in editor

    Hi all
    I've got quite a stupid problem but it's annoying me and I can't seem to correct it. When I first started with VBA, the editor window displayed the project, properties and code windows nicely spaced according to each window. Somewhere along the line I moved things around but now I want it back. I know it's not a big problem but an inconvenience every time. Sure, I can tile the windows but then the project window is way bigger than what I want (with code window too small). I can customize the windows and move them to where I want but every time I open another sheet's code, it is floating over other windows and I have to move it again.
    If anyone knows how to reset that, please let me know.
    Thanks
    Alan

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Resetting to original window position in editor

    In the VBE go Tools > Options > Docking
    Click all but the last box and OK
    Then for the fine tuning, check http://www.excelforum.com/excel-prog...ml#post2615826

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,990

    Re: Resetting to original window position in editor

    If you want to reset the whole VBE to the defaults, you can simply delete the Settings hive at:
    HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0
    (or 7.0 for Office 2010)
    Everyone who confuses correlation and causation ends up dead.

  4. #4
    Registered User
    Join Date
    08-17-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    35

    Re: Resetting to original window position in editor

    Thanks. You saved me lots of frustration :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1