VB Window

[damorrison]

How can I reset the VB window to its original format?

[Gord Dibben]

What do you consider the "original format"?

Maybe a good place to start would be with the Project Explorer window open(hit
CTRL + r)

Then Tools>Options>Docking and uncheck all options..

Do some re-sizing and restoring of various windows until you get what you like.

I have found that trial and error gets me what I want.


Gord Dibben MS Excel MVP

On 11 Mar 2006 10:49:04 -0800, "damorrison" <davemcochrane@gmail.com> wrote:

>How can I reset the VB window to its original format?

[Dave Peterson]

This was 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.

==========
Close excel
Windows start button|run
regedit
to be able to edit the registry.

damorrison wrote:
>
> How can I reset the VB window to its original format?

--

Dave Peterson