VBA Editor Window(s) size challenge
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
|