missing toolbar

[steph]

I'm not really a new user but this frustrating problem is probably simple to
resolve. I am now missing the toolbar that is typically at the top of all
EXCEL spreadsheets--the one that shows FILE, EDIT, VIEW, etc. I thought that
was the STANDARD toolbar, however, if I right click next to the visible
toolbars, both STANDARD and FORMATTING are checked.

What did I do? More importantly, how do I fix this? PLEASE HELP--I can't
function well without this!!

 

[George Gee]

Right click your toolbars > Customize.
On the Toolbars tab checkmark in 'Worksheet Menu Bar'

George Gee

 

[Gord Dibben]

The name of that is Worksheet Menu Bar

You can try Tools>Customize>Toolbars and select it if not checked.

It may have been disabled somehow and needs to be re-enabled

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


Gord Dibben MS Excel MVP

 

[steph]

that worked--thank you very much!