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.
- Close All Office programs.
- Run RegEdit. Open a command prompt and type
regedit
. - Navigate to
HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
, orVBA\7.0
and maybe latter versions. - Delete the value of Dock key.
- Close RegEdit.
- Open Excel and VBE, the windows are now at their default positions.