excel menu bar missing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The main menu bar containing "File Edit Tools etc" is missing
How do I get it back.
I have reloaded excel with no results

Trevor
 
View > Toolbars > Customize > tick: Worksheet Menu Bar

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
I think View is on the worksheet menu bar so how can you access View? <g>

Right click *any* toolbar then: Customize > tick: Worksheet Menu Bar

Biff
 
Good Point! (sheepish) <g>

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Try this:

Right-click in the gray area at the top of the window
(You'll see a list of available toolbars, but not the one you want)

Select: Customize
Select: Toolbars tab
Check: Worksheet Menu Bar
Click: [OK]


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Trevor,

I was having the same problem, but if you right click on the toolbar and see
if the minimize ribbon is checked then uncheck it. This is with excel 2007.
 
Trevor,

I was having the same problem, but if you right click on the toolbar and see
if the minimize ribbon is checked then uncheck it. This is with excel 2007.






- Show quoted text -
Click to expand...

What used to be the file menu is the circular button in the upper left
with the Microsoft Logo in it. After 10 years working with Excel I
installed 2007 last week and it took 15 minutes to figure out how to
open a file.
 
Sidd said:
The main menu bar containing "File Edit Tools etc" is still missing
Click to expand...
I've landed in this discussion group with a similar problem. Using Excel
2003, very abruptly today I have *no toolbars at all (nothing to click and
change the view) save for two custom toolbars I've used for a long time. I
do *not have the option, (on clicking in the greyed area or using the down
arrow on either menu) to select or add the customary standard toolbars, as
none of them are listed, even by clicking 'customise'. Either this is a view
problem (which I can't change because I have no view) or I've lost what I'd
think would be the corollary to normal.dot in the Word environment. Ideas
please? I'm lost and desperate and under some time constraints.
Thanks a lot. Marguerite Foraminut
 
You could look for Excelxx.XLB file which is the file that saves your Menu setup
and customizations.

Rename it to Excelxx.old then re-start Excel to see what happens.

This will delete your customizations including the toolbars you built.

I would try this macro first. You may not have to delete your customizations.

Sub Worksheet_Menu_Hide()
If Application.CommandBars("Worksheet Menu Bar").Enabled = True Then
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Else
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End If
'''Application.CommandBars("new bar name").Visible = True
End Sub

Paste it into a general module and Run>Run Sub/Userform from the VBEditor
Toolbar.

To get to the VB Editor hit Alt + F11 then CTRL + r. Find your workbook/project
and right-click and insert>module.

Paste the macro into that module.
 
Back
Top