Discussion Locked

Excel - User deleted the main menu

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I restore the main menu in Excel? The user deleted it, so I'm not sure if Office repair would do anything.

4 replies

by dklippert

Go to View>Toolbars
Choose Customize.
On the Toolbars tab place a check in Worksheet Menu bar.
If needed, click the Reset button to restore the menus to default status.

by dklippert

Here's another suggestion:

Press ALT+F11, Insert > Module, and paste this code in:

Sub ShowIt()
Application.CommandBars.ActiveMenuBar.Enabled = True
End Sub

Now run the macro and close out of VBE.

This discussion is closed to new replies.