ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Split Screen in VBA Editor (https://www.excelbanter.com/excel-discussion-misc-queries/185266-split-screen-vba-editor.html)

BillCPA

Split Screen in VBA Editor
 
In VBA Editor, I used to have (I think) a split vertical screen. The Project
Explorer window and the Properties window would show up in the left pane, and
the code and forms windows would show up in the right pane.

Somehow I have lost that split. Don't know what I did to change it, but I
would like to have it that way again. Can anybody help?

--
Bill @ UAMS

FSt1

Split Screen in VBA Editor
 
hi
you didn't say which one you lost so i'm guessing the project explorer.
on the menu bar of the vb editor.
Viewproject explorer.
note: in the up right corner is an "X". you may have hit it accidently.
Other items on the view menu can be called and killed as needed/wanted. all
have the "X".
the code window is the only one that doesn't have an "X".(that i know of)

regards
FSt1
"BillCPA" wrote:

In VBA Editor, I used to have (I think) a split vertical screen. The Project
Explorer window and the Properties window would show up in the left pane, and
the code and forms windows would show up in the right pane.

Somehow I have lost that split. Don't know what I did to change it, but I
would like to have it that way again. Can anybody help?

--
Bill @ UAMS


Dave Peterson

Split Screen in VBA Editor
 
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.



BillCPA wrote:

In VBA Editor, I used to have (I think) a split vertical screen. The Project
Explorer window and the Properties window would show up in the left pane, and
the code and forms windows would show up in the right pane.

Somehow I have lost that split. Don't know what I did to change it, but I
would like to have it that way again. Can anybody help?

--
Bill @ UAMS


--

Dave Peterson

BillCPA

Split Screen in VBA Editor
 
Worked perfectly - thanks so much.

I do some things with the code windows in my code, and it had really messed
that up.

Life is good.

--
Bill @ UAMS


"Dave Peterson" wrote:

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.



BillCPA wrote:

In VBA Editor, I used to have (I think) a split vertical screen. The Project
Explorer window and the Properties window would show up in the left pane, and
the code and forms windows would show up in the right pane.

Somehow I have lost that split. Don't know what I did to change it, but I
would like to have it that way again. Can anybody help?

--
Bill @ UAMS


--

Dave Peterson



All times are GMT +1. The time now is 02:05 AM.

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