Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Don't know what I did but the VBE window used to show:
The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Close Excel
start regedit find the key HKEY_USERS\.DEFAULT\Software\Microsoft\VBA\Office That is for excel 97 on Windows 98 SE for xl2000 (under Windows 2000) search under HKEY_USERS\.DEFAULT\Software for a Key named VBA, then under that 6.0\Common Find the Key named Dock and delete it. Then open excel and the VBE should be back to the default. ----------------------------------- If Version 2002 or 2003 look for HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\Dock -- Regards, Tom Ogilvy "STEVE BELL" wrote in message news:Kh%pe.7754$xI2.146@trnddc09... Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Tom,
You are a champ!!! Should have told you that it is Office 2000, Windows XP. But finally found it! Also had to delete one about folder view to get my folders into the project window. Again - Thanks for the quick response and excellent fix... -- steveB Remove "AYN" from email to respond "Tom Ogilvy" wrote in message ... Close Excel start regedit find the key HKEY_USERS\.DEFAULT\Software\Microsoft\VBA\Office That is for excel 97 on Windows 98 SE for xl2000 (under Windows 2000) search under HKEY_USERS\.DEFAULT\Software for a Key named VBA, then under that 6.0\Common Find the Key named Dock and delete it. Then open excel and the VBE should be back to the default. ----------------------------------- If Version 2002 or 2003 look for HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\Dock -- Regards, Tom Ogilvy "STEVE BELL" wrote in message news:Kh%pe.7754$xI2.146@trnddc09... Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
All windows are "dockable" Grab the title bar of the Project window and drag
it back to where you would like it. It should zap back to where you want it "STEVE BELL" wrote: Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Thank you!
Played with it and it worked! (Don't know why I forgot that.) (Guess I must have accidently done that ...) But why did I lose the folders in the project window? Tom's advice worked to get those back... -- steveB Remove "AYN" from email to respond "bigwheel" wrote in message ... All windows are "dockable" Grab the title bar of the Project window and drag it back to where you would like it. It should zap back to where you want it "STEVE BELL" wrote: Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Tom's answered your docking question. The Project Explorer 'folder view' can
be changed by clicking the icon at the top of the Project Explorer window that looks a bit like a folder. -- Regards Stephen Bullen Take your Excel development to the highest levels with "Professional Excel Development", www.oaltd.co.uk/ProExcelDev "STEVE BELL" wrote: Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE Window not working correctly
Thank you...
I have learned some important basics from everyone's replies.... As always this site is a blessing... -- steveB Remove "AYN" from email to respond "Stephen Bullen" wrote in message ... Tom's answered your docking question. The Project Explorer 'folder view' can be changed by clicking the icon at the top of the Project Explorer window that looks a bit like a folder. -- Regards Stephen Bullen Take your Excel development to the highest levels with "Professional Excel Development", www.oaltd.co.uk/ProExcelDev "STEVE BELL" wrote: Don't know what I did but the VBE window used to show: The Project window locked on the left side of the screen and the Module windows locked to the right. Now the Project window locks across the top of the screen and the Module windows lock on the bottom. Also the Project window no longer shows folders for Objects, Modules, etc - it just lists everything. Have played with Options and have been unable to return to the former configuration. Can anyone be so kind to offer suggestions on what may have happened? tia -- steveB Remove "AYN" from email to respond |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If function not working correctly | Excel Discussion (Misc queries) | |||
AutoSum not working correctly | Excel Discussion (Misc queries) | |||
Hyperlink not working correctly | Excel Discussion (Misc queries) | |||
vlookup isn't working correctly? | Excel Discussion (Misc queries) | |||
Autofilter not working correctly... | Excel Discussion (Misc queries) |