Thread: VB Editor
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default VB Editor

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\Commo n\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.



mlh wrote:

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


--

Dave Peterson