ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA View Settings (https://www.excelbanter.com/excel-discussion-misc-queries/188222-vba-view-settings.html)

Jeff

VBA View Settings
 
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.

Nick Hodge[_2_]

VBA View Settings
 
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.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





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



Dave Peterson

VBA View Settings
 
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.

Jeff wrote:

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.


--

Dave Peterson

Jeff

VBA View Settings
 
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.

"Nick Hodge" wrote:

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.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





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




All times are GMT +1. The time now is 07:03 PM.

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