#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 185
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View settings DKS Excel Discussion (Misc queries) 1 December 24th 07 12:42 PM
How to turn off Page Layout View as default view Colin Halliday New Users to Excel 3 October 12th 07 02:37 AM
settings not saved w/custom view DR support Excel Worksheet Functions 0 February 20th 06 05:15 PM
some view settings could not be applied AlanMagpie Excel Discussion (Misc queries) 0 October 14th 05 01:28 PM
Default View Settings Gina Setting up and Configuration of Excel 0 January 25th 05 05:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"