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

Solution Using a Mac and Excel 2016.

I found that I could drag the, e.g., project explorer (pe) window toward the edge of the vb window and the outline of the pe window moves and adjusts once you get close enough to the edge. This also works with the other windows as you bring them into view.

My default view is project explorer upper left, properties lower left. To return these to be in that order, drag the one to that location (which will fill that whole area) then drag the other one right on top of that one. That stacks them in the same column and then you can adjust their size within those locations.

Answer 2

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.

Answer 3

I'm not aware of a 'reset' command but the starting point would be to go to the View menu and start by setting the Code, Project Explorer and Properties windows and then the Toolbars>Standard (toolbar) perhaps?