Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split screen | Excel Discussion (Misc queries) | |||
Excel 2003 split screen | Excel Discussion (Misc queries) | |||
HOW DO i UNDO A SPLIT SCREEN | Excel Discussion (Misc queries) | |||
Unwanted replicated split screen | Excel Discussion (Misc queries) | |||
Split Screen | Excel Worksheet Functions |