| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Window - Problems with the display
Hello, Somehow I've when viewing the VBA code in excel I've lost the split
screen that normally occurs when you open the code. I can display either Project Explorer or the Code in a full window, but not both alongside each other. I've tried everything on the toolbars to make it work and resized the windows but nothing will put them back together. Does anyone have any suggestions.? Windows XP Professional = Excel 2003 This was inadvertent and not intentional so I don't have a clue how it happened. Thanks in advance BOB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Window - Problems with the display
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. LabrGuy Bob R wrote: Hello, Somehow I've when viewing the VBA code in excel I've lost the split screen that normally occurs when you open the code. I can display either Project Explorer or the Code in a full window, but not both alongside each other. I've tried everything on the toolbars to make it work and resized the windows but nothing will put them back together. Does anyone have any suggestions.? Windows XP Professional = Excel 2003 This was inadvertent and not intentional so I don't have a clue how it happened. Thanks in advance BOB -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Window - Problems with the display
Are there "resore" and "Close" buttons on the grey menu line under the ones
for the VBA editor (on the blue bare) "LabrGuy Bob R" wrote: Hello, Somehow I've when viewing the VBA code in excel I've lost the split screen that normally occurs when you open the code. I can display either Project Explorer or the Code in a full window, but not both alongside each other. I've tried everything on the toolbars to make it work and resized the windows but nothing will put them back together. Does anyone have any suggestions.? Windows XP Professional = Excel 2003 This was inadvertent and not intentional so I don't have a clue how it happened. Thanks in advance BOB |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Window - Problems with the display
Thanks to both of you. Restore and Close didn't appear, but the information
Dave Peterson gave me was right on. Thanks so much. BOB "barnabel" wrote in message ... Are there "resore" and "Close" buttons on the grey menu line under the ones for the VBA editor (on the blue bare) "LabrGuy Bob R" wrote: Hello, Somehow I've when viewing the VBA code in excel I've lost the split screen that normally occurs when you open the code. I can display either Project Explorer or the Code in a full window, but not both alongside each other. I've tried everything on the toolbars to make it work and resized the windows but nothing will put them back together. Does anyone have any suggestions.? Windows XP Professional = Excel 2003 This was inadvertent and not intentional so I don't have a clue how it happened. Thanks in advance BOB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2007, the open file window does not display the folders p | Excel Discussion (Misc queries) | |||
| display program and file name at top of window in Excel | Excel Discussion (Misc queries) | |||
| New window in Excel does not display default settings | Excel Discussion (Misc queries) | |||
| Excel Window Zoom Problems | Excel Programming | |||
| Changing the text in the top excel window bar to display your own. (Tip & Question). | Excel Programming | |||
Linear Mode
