How can I reset VBA's default settings in Microsoft Excel

[Al Kaholic]

Somehow I changed the VBA setting and I want to change it back to the default. Can someone explain it to me. I hit dock and now nothing looks right. I tried to unlock but can not find out how to.

[Panop]

When I screw up the layout (including the tiling). What version of excel. If Version 2002 or 2003 look for HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock you aren't deleting a file. You are deleting a value in the registry. Windows/Excel will recreate it with default values which should restore the original layout of the VBE.

[Go!pee]

Right-click on whatever window you docked, and uncheck Dockable. Select all check boxes except the first (automatic syntax checking, more annoying than useful). The activation of important variables to be declared. This forces you to at least begin to ordinary variable declaration. Change the defaults here only if you no one is working out in the development environment, otherwise the changes will affect interferes with third parties.