Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Restore the VBE windows to their default positions

 2000-02-05    VBE    0    205

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.

  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.