![]() |
How do I hide and show all toolbars
I have a next scenario, when I open Excel 2003 all the Menu Bars are hidden,
they do not appear visible incluiding the Worksheet Menu Bar. Only there is the title of Microsft Excel - Book 1 and immediately below there are the columns A B C D E.. etc. How I can make again appear menus without having the option of right click to make appear the options of the toolbars? |
Quoting Dave Peterson: 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). Quoting Jason Morin from Atlanta: 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 Hope this helps Sunil Jayakumar "Quinam" wrote in message ... I have a next scenario, when I open Excel 2003 all the Menu Bars are hidden, they do not appear visible incluiding the Worksheet Menu Bar. Only there is the title of Microsft Excel - Book 1 and immediately below there are the columns A B C D E.. etc. How I can make again appear menus without having the option of right click to make appear the options of the toolbars? www.ayyoo.com/dvd.html |
All times are GMT +1. The time now is 05:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com