VBA View Settings

[Jeff]

Hi,

I dont know how this happened, but when I view code in vba, the windows for
the code, the "Project Explorer" are all floating around, and they do not
resize, so it is a real pain to navigate around. I have been trying for a
while to get back to the original setting.

Does anyone know how to do this?

Thanks for your help.

 

[Nick Hodge]

Jeff

If you still have one window docked, drop the others over the title bar of
the one that is docked and it will dock above that. If this is the wrong way
around, just drag the first window back over the title bar of the newly
docked one and let it go.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Dave Peterson]

Sometimes, it's easier to start from scratch...

Follow the instructions posted by Tom Ogilvy:

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.

 

[Jeff]

The problem is that the windows are not "Fixed" - I mean I can move them
around, usually they are set and you can adjust the size. I need to get the
windows back so that they are fixed. I can't drag the title bars around.