Thread
:
VBA Editor Window(s) size challenge
View Single Post
#
10
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
VBA Editor Window(s) size challenge
That sounds much better.
wrote:
I'll revise my steps:
1) Close Excel
2) As Dave mentioned:
In RegEdit: (backup your Registry first!) (For Excel 2000, 2003, 2007)
Find: HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\Dock
Delete it.
Close RegEdit
3) Open Excel
4) In VBE Editor (Alt + F11) position the windows you wish "docked" first.
(Note that the Code window is not Dockable) - so bring it up after #5 next.
5) Resize your Immediate Window AFTER it is docked. (My case bottom right)
6) Bring up your last window (Code window in my case - Upper Right) and maximize it.
7) Now all four windows are EFFECTIVELY Docked and all scroll and slide bars should be visible and
usable in all four boxes
8) Save your file using the Save button in the VBE Editor
Thanks Dave!
Dave Peterson wrote:
I saved the contents of Tom's post. You could use google groups to search for
it if you want.
And you delete the Dock key--not the entire Comman branch.
It's the same key for xl2007--I just tried it and it worked fine for me.
And did you have excel closed when you did this?
wrote:
Hello Dave,
I saw your comment using Google Search to a prior post to someone else.
My immediate version is 2007. Even still, I found that registry entry and deleted same.
Is it necessary to re-boot the o/s and/or just re-initiate Excel?
Do you have easy access to Tom's link?
My concern is whether the delete is just to "Dock" key
or to "Common." I deleteted just the "Dock" key and that did not bring me back the the "Ole"
windows..
EagleOne
Dave Peterson wrote:
When I screw up the layout (including the tiling), I'll just follow these
instructions from Tom Ogilvy:
What version of excel? If Version 2002 or 2003 look for
HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Comm on\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.
wrote:
2003/2007
For years, I have been able to have four stable (size) windows open in the VBA Editor.
Project Explorer Code Window
Properties Immediate Window
Unless I am crazy, all four of those windows were fixed size. Meaning that no matter what module of
the project was double-clicked, the code window would change to the newly selected module-code
and all four windows were distinct (no windows overlapped any other).
Recently, I found that my Immediate Window overlaps the bottom of my Code Window which screws up
what I can scroll-to in the Code Window.
Certainly, I screwed something up. I have tried many ways to resize the Windows and "Docking"
on/off selections but I can not find my "good old" four stable windows.
Any suggestions greatly appreciated!
EagleOne
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson