Arranging the VBA console windows
 

It didn't used to be this way, but these days when I go to
the VBA console from Excel (e.g., via Alt-F11) about 20 windows
and views open up in ways I don't like at all. I close most
of them and rearrange the few I want to view, but the next time
I open the worksheet and go there again, it's all a big mess
again.

I don't understand what I need to do to revert to the clean
OEM screen I used to have. I recall I had windows docked,
like so, at some point and like it:

+-------------------------------------------------------------------+
| | |
| | |
| | |
| | |
| Project | |
| Explorer | |
| | Code Window |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
+-------------------+ |
| | |
| | |
| Properties | |
| Window | |
| | |
| | |
| | |
| | |
| | |
+-------------------------------------------------------------------+

When I try docking or dragging or rearanging windows, I just can't
get back to this clean thing and have it stick. What am I doing wrong?

Thanks,
Dallman

Arranging the VBA console windows
 

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.

Dallman Ross wrote:

It didn't used to be this way, but these days when I go to
the VBA console from Excel (e.g., via Alt-F11) about 20 windows
and views open up in ways I don't like at all. I close most
of them and rearrange the few I want to view, but the next time
I open the worksheet and go there again, it's all a big mess
again.

I don't understand what I need to do to revert to the clean
OEM screen I used to have. I recall I had windows docked,
like so, at some point and like it:

+-------------------------------------------------------------------+
| | |
| | |
| | |
| | |
| Project | |
| Explorer | |
| | Code Window |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
+-------------------+ |
| | |
| | |
| Properties | |
| Window | |
| | |
| | |
| | |
| | |
| | |
+-------------------------------------------------------------------+

When I try docking or dragging or rearanging windows, I just can't
get back to this clean thing and have it stick. What am I doing wrong?

Thanks,
Dallman

--

Dave Peterson

Arranging the VBA console windows
 

In , Dave Peterson
spake thusly:

Follow the instructions posted by Tom Ogilvy:

What version of excel? If Version 2002 or 2003 look for

Yup, 2002.

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.

Thank you! (And Tom.) That's exactly what I needed.

================================================== =========================
Dallman Ross wrote:

It didn't used to be this way, but these days when I go to
the VBA console from Excel (e.g., via Alt-F11) about 20 windows
and views open up in ways I don't like at all. I close most
of them and rearrange the few I want to view, but the next time
I open the worksheet and go there again, it's all a big mess
again.

I don't understand what I need to do to revert to the clean
OEM screen I used to have. I recall I had windows docked,
like so, at some point and like it:

+-------------------------------------------------------------------+
| | |
| | |
| | |
| | |
| Project | |
| Explorer | |
| | Code Window |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
+-------------------+ |
| | |
| | |
| Properties | |
| Window | |
| | |
| | |
| | |
| | |
| | |
+-------------------------------------------------------------------+

When I try docking or dragging or rearanging windows, I just can't
get back to this clean thing and have it stick. What am I doing wrong?

Thanks,
Dallman