» Restore the VBE windows to their default positions using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - General Topics in VBA
VERSION - All Microsoft Excel Versions
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.
- Close Excel and the VBE.
- Run RegEdit.
- Navigate to HKEY_USERS\.Default\Software\Microsoft\VBA\Office.
- Rename (or delete) the value Dock (e.g. ;Dock), Excel will recreate it when it starts next time.
- Close RegEdit.
- Open Excel and VBE, the windows are now at their default positions.
Book Store:
Recommended Books:
- Wall Street Journal Guide to Understanding Money and Investing
- How to Pay Zero Taxes (Annual)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Advanced modelling in finance using Excel and VBA
No comments have been submitted.
