How to reset the VBE windows to their default positions

If you have some troubles with macro and projects explorer windows settings, after some bad manipulations. How to reset the VBE windows to their default positions?

Note! Back up the Registry before you edit it.

  1. Close All Office programs.
  2. Run RegEdit. Open a command prompt and type regedit.
  3. Navigate to HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common, or VBA\7.0 and maybe latter versions.
  4. Delete the value of Dock key.
  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 *