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 / Setup / March 2004

Tip: Looking for answers? Try searching our database.

Excel Menu Bar Lost

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Jeffery - 05 Mar 2004 17:32 GMT
This is a follow-up to my previous post.

I have somehow lost the main menu bar (File, Edit, View,
etc) in Excel 2000 and cannot get it back. I have
run 'detect and repair' but that didn't correct the
problem. Can anyone help me?

It will not come back using the 'customise' function.

It is not 'hidden' as the short-cut keys don't operate.

I have made a temporary fix by creating a custom bar and
adding the commands to it, but this is not fully correct -
every Title e.g. 'File' has a drop-down arrow at the side,
and the 'Alt +' keys don't operate for this type of custom
bar. I had to make this bar so that I could look if there
was anything in the 'Options', but couldn't find any help
there.

My boss says he was trying to change something and he
thinks he deleted it!!!! - (They think they know
everything).

Any help to get back the original bar would be much
appreciated.

John Jeffery.
Gord Dibben - 05 Mar 2004 23:28 GMT
John

With a workbook open, hit ALT + F11 to get to the Visual Basic Editor.

View>Immediate window

Copy/paste the code line below into the Immediate window and hit <ENTER>

Application.CommandBars("Worksheet Menu Bar").Enabled = True

ALT + Q to get back to Excel with, hopefully, a restored Worksheet Menu

Gord Dibben Excel MVP

>This is a follow-up to my previous post.
>
[quoted text clipped - 23 lines]
>
>John Jeffery.
 
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.