Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i get my menu bar back?
I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but
that is not even listed in my toolbar section in the Customize box. Any other ideas? |
#2
|
|||
|
|||
If you right click on any bar you have left (one with buttons on it) and go
down to customise. you'll get a box appear with a tab on it labeled toolbars. Scroll to the bottom and tick the checkbox next to "worksheet menu bar" and it should come back. Let me know how you get on "Rienne" wrote: I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but that is not even listed in my toolbar section in the Customize box. Any other ideas? |
#3
|
|||
|
|||
Press ALT+F11, go to Insert Module, copy in the code
below, press ALT+Q, and run the macro from Tools Macros Macro: Sub EnableIt() Application.CommandBars("Worksheet Menu Bar"). _ Enabled = True End Sub HTH Jason Atlanta, GA -----Original Message----- I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but that is not even listed in my toolbar section in the Customize box. Any other ideas? . |
#4
|
|||
|
|||
Unfortunatley, the Worksheet Menu Option wasn't even listed. Thanks for the
help though. "DB Queen (Not)" wrote: If you right click on any bar you have left (one with buttons on it) and go down to customise. you'll get a box appear with a tab on it labeled toolbars. Scroll to the bottom and tick the checkbox next to "worksheet menu bar" and it should come back. Let me know how you get on "Rienne" wrote: I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but that is not even listed in my toolbar section in the Customize box. Any other ideas? |
#5
|
|||
|
|||
Is it ok to reset all your toolbars???
If yes, then close excel. windows start button|search look for *.xlb (.xlb is where toolbar customizations are saved) Rename them all to *.xlbOLD Start up excel to see if it's ok. If yes, delete those *.xlbOLD files. If no, close excel and rename them back (no harm, no foul). Rienne wrote: I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but that is not even listed in my toolbar section in the Customize box. Any other ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Goal Seek back after deleting it from the Tools menu. | Excel Discussion (Misc queries) | |||
Menu Bar | Setting up and Configuration of Excel | |||
How do I get default menus back in Excel? | Excel Discussion (Misc queries) | |||
My file menu is not on the menu bar. | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |