ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VB Editor (https://www.excelbanter.com/excel-discussion-misc-queries/148430-vbulletin-editor.html)

mlh

VB Editor
 
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

VB Editor
 
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

"mlh" wrote in message
...
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

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


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com