VBA View Settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 20 May 2008 20:54 GMT

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.

Reply to this Message

Nick Hodge - 20 May 2008 21:26 GMT

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.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks for your help.

Reply to this Message

Jeff - 21 May 2008 14:57 GMT

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.

> Jeff
>
[quoted text clipped - 14 lines]
> >
> > Thanks for your help.

Reply to this Message

Dave Peterson - 20 May 2008 23:31 GMT

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.

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks for your help.

Signature

Dave Peterson

Reply to this Message