HELP: Menu bar disappear

Nina

New Member
Joined
May 14, 2003
Messages
19
The Menu disappear, how do I get it back?

I mean the File Edit View Insert... bar.

Thanks!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
First step... Right mouse click in the grey area to the right of the Toolbars.

You should have a series of Options, in most cases, all of the ones above customise should be ticked.
If not, and even if yes, click on customise, and reset the toolbars, and redo your primary toolbar options.

(y)
 
Upvote 0
It is not the toolbar that disappeared. It is the menu bar that disappeared. Thanks!
 
Upvote 0
That approach worked for me in resetting the Menu Bar.
Best Suggestion I can make, because there are so many reasons why a Menu Bar can disappear, is to press F1, search for Menu bar, and see what applies.
Thats the best I can do in the alternative.

(y)
 
Upvote 0
Hi Nina,

In the VBE (Alt & F11) paste the following routine into a module and then run it.
Code:
Sub ComeBack()
    Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub
HTH
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top