ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I hide and show all toolbars (https://www.excelbanter.com/excel-worksheet-functions/21633-how-do-i-hide-show-all-toolbars.html)

Quinam

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?

Sunil Jayakumar


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