Restore the VBE windows to their default positions using VBA in Microsoft Excel

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.
  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.


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.