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

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

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

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

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

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

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