Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 101
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 101
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
split screen George A. Yorks Excel Discussion (Misc queries) 0 September 25th 07 02:36 PM
Excel 2003 split screen Chip Smith Excel Discussion (Misc queries) 0 August 4th 06 12:21 AM
HOW DO i UNDO A SPLIT SCREEN bobd5230 Excel Discussion (Misc queries) 2 January 30th 06 09:57 PM
Unwanted replicated split screen BoyLeroy Excel Discussion (Misc queries) 1 September 28th 05 07:09 AM
Split Screen sh0t2bts Excel Worksheet Functions 3 January 6th 05 09:38 PM


All times are GMT +1. The time now is 01:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"