Restore the VBE windows to their default positions
2000-02-05 VBE 0 214
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.
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.