VBE Window not working correctly

[STEVE BELL]

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

 

[Tom Ogilvy]

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\Common\Dock

 

[STEVE BELL]

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...

 

[Guest]

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]

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...

 

[Guest]

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]

Thank you...

I have learned some important basics from everyone's replies....

As always this site is a blessing...