How to restore VBA Editor to its initial settings? How to restore VBA Editor to its initial settings? vba vba

How to restore VBA Editor to its initial settings?


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 ofits 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.


I have the same issue, it's simple:

TOOLSOPTIONSDOCKING

     Then select Object Browser, Project Explorer and that's all.


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.