VB Editor

[mlh]

Previously both project explorer and the code window (is that the correct
word) were docked together. If I added a new module this too would 'dock' to
the project explorer.

I don't recall changing anything but now if I add a new module the window
isn't docked and I can't make it dock.

I've played around with the docking options in the Vb editor but no luck.

Any guidance?

mlh

 

[Bob Flanagan]

Right click on the window heading bar of the windows that won't dock, and
click on the option "dockable"

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

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