Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 222
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default 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
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
If function not working correctly Relle Excel Discussion (Misc queries) 10 September 16th 09 10:42 AM
AutoSum not working correctly JimBUFF Excel Discussion (Misc queries) 2 November 9th 08 09:36 PM
Hyperlink not working correctly DonnaO Excel Discussion (Misc queries) 0 November 20th 07 10:45 AM
vlookup isn't working correctly? Dave F Excel Discussion (Misc queries) 2 October 14th 06 04:27 AM
Autofilter not working correctly... Emily Excel Discussion (Misc queries) 0 January 11th 06 10:37 PM


All times are GMT +1. The time now is 02:34 PM.

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"