ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Restore the VBE windows to their default positions

If you have trouble with the docking of the different VBE windows, you can restore their positions by editing a setting in the Registry.

Note! Back up the Registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Use Registry Editor at your own risk.

  1. Close Excel and the VBE. 
  2. Run RegEdit. 
  3. Navigate to HKEY_USERS\Default\Software\Microsoft\VBA\Office (pre Windows 2000) or
    HKEY_CURRENT_USER/Software/Microsoft/VBA/6.0/Common (Windows 2000 or later)
  4. Rename (or delete) the value Dock (e.g. ;Dock), Excel will recreate it when it starts next time. 
  5. Close RegEdit. 
  6. Open Excel and VBE, the windows are now at their default positions.

 

Document last updated 2000-02-05 12:51:07      Printerfriendly version

User comments:
Willem Denekamp from Elspeet, The Netherlands wrote (2003-11-13 09:02:50 CET):
Restore the VBE windows to their default docking position in OS WIN2000
The Path in the Register of Win2000 to restore the default docking position of the different VBE windows is:

\HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock

Thanks for your excellent Tips and Webpage-layout.

Willem

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address