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? |
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? |
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? . |
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? |
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 |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com