How to restore VBA Editor to its initial settings?

excel vba vbe
Stefyu Thechosenone picture Stefyu Thechosenone · Nov 7, 2014 · Viewed 31.9k times · Source

How to restore the VBA Editor to its intial settings ? I have some troubles with macro and projects explorer windows settings, after some bad manipulations.

Answer

RubberDuck picture RubberDuck · Nov 7, 2014

The only way I know how to accomplish this is to edit the registry.

  1. Close All Office programs
  2. Open a command prompt and type regedit
  3. Navigate to HKEY_CURRENTUSER\Software\Microsoft\VBA\6.0\Common
  4. Right click on Common and Export to save the *.reg file somewhere safe. This is your back up. Double clicking this file will restore your current settings.
  5. Right click on Common and Delete it. Doing this will remove all of its subkeys that hold your personal settings.

The "Common" key will be recreated the next time you close the VBA Editor along with any changes to the settings you may make.

Related questions

Copy VBA code from a Sheet in one workbook to another?

I've been using the lines below to compy VBA modules from one workbook to another and I don't know if there is an easier way, but they have been working fine: Set srcVba = srcWbk.VBProject Set srcModule = srcVba.VBComponents(moduleName) …

Read More
Changing language of Visual Basic Editor to English

After Microsoft Office updated to the 2016 version I found the VBA interface is in German. How can I restore it to English? My Windows 10 settings are set to English and the local setting preferences are all for English UK as …

Read More
Use Python to Inject Macros into Spreadsheets

I've got a macro that I'd like a bunch of existing spreadsheets to use. The only problem is that there are so many spreadsheets that it would be too time consuming to do it by hand! I've written a Python …

Read More