excel - How to restore VBA Editor to its initial settings?

Question

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 1

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_CURRENTUSERSoftwareMicrosoftVBA6.0Common
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.