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.
- Close Excel and the VBE.
- Run RegEdit.
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)
- Rename (or delete) the value Dock (e.g. ;Dock), Excel will recreate it when it starts next time.
- Close RegEdit.
- Open Excel and VBE, the windows are now at their default positions.
Document last updated 2000-02-05 12:51:07
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:
Thanks for your excellent Tips and Webpage-layout.