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
- Navigate to
VBA\7.0and maybe latter versions.
- Delete the value of Dock key.
- Close RegEdit.
- Open Excel and VBE, the windows are now at their default positions.