Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

Lost menu bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bagwash - 31 Mar 2007 15:37 GMT
Using Excel 2000, regularly and extensively. Suddenly I've lost the menu bar
in all my spreadsheets and any new ones that I create.

Clicking on a toolbar then <Customise> shows the <Worksheet menu bar> to be
checked. (And if I uncheck it, it simply restores the check) The menu bar,
however, does appear if I check <Chart menu bar>, but it instantly
disappears when I close the <Customise> window. And when it is there I can
click on and see the drop-down menus but it doesn't respond to further
keystrokes.

I've run the Office 2000 Professional installation disk to <Repair> but with
no effect.

Can't say exactly what version I've got as I can't access the <Help> menu!!!

Suggestions gratefully received.
Dave Peterson - 31 Mar 2007 16:03 GMT
First, if you're looking at a chart sheet (not a worksheet), you shouldn't see
the Worksheet Menu Bar.

I'd try this first.
Activate a worksheet.
Then rightclick on an empty spot on any toolbar.
Customize|Toolbars tab|
Select worksheet menu bar and click Reset.

Then check to see if it worked.

If it didn't, I'd do this next:

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g  to see the immediate window.

Type this and hit enter:
application.commandbars("worksheet menu bar").enabled = true

Back to excel to see if it worked.

If that didn't work, maybe you can just delete the file that excel uses to keep
track of toolbars.

Close excel
Windows search button
search for *.xlb
(in hidden folders, too!)

Rename all you find to *.xlbOLD
(or delete them???)

This will remove any customizations that you've made to any toolbar.  You'll
have to rebuild those at your leisure.

If you're happy with the results, delete the *.xlbOLD files.

If you're not happy, close excel and rename those *.xlbOLD files back to *.xlb.

> Using Excel 2000, regularly and extensively. Suddenly I've lost the menu bar
> in all my spreadsheets and any new ones that I create.
[quoted text clipped - 12 lines]
>
> Suggestions gratefully received.

Signature

Dave Peterson

bagwash - 31 Mar 2007 18:22 GMT
That's the strange thing - it IS a worksheet and not a chartsheet. I had
tried your first suggestion, but will now the second - thanks - but later as
here in the south of England it's a lovely spring afternoon and the garden
comes first!

> First, if you're looking at a chart sheet (not a worksheet), you shouldn't
> see
[quoted text clipped - 61 lines]
>>
>> Suggestions gratefully received.
bagwash - 31 Mar 2007 22:47 GMT
A thousand thanks - I worked through your suggestions and restored the menu
bar (and my sanity) by deleting the Excel.xlb file.

Enormously appreciated.

> That's the strange thing - it IS a worksheet and not a chartsheet. I had
> tried your first suggestion, but will now the second - thanks - but later
[quoted text clipped - 66 lines]
>>>
>>> Suggestions gratefully received.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.