How do I hide and show all toolbars

Q

Quinam

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?
 
S

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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top