My excell tool/menu bar disappeared and I cant find it or get it

R

Ron de Bruin

Hi Littkerl

Do you see other toolbars on your screen ?

You can reset your menubar to default
Right click on a toolbar and choose customize

Under Toolbars select the worksheet menu bar
and click on reset

If not post back
 
K

Kent Finnell

Littkerl said:
My excell tool bar / menu dissapeared and I can't get it back? any help?
Click to expand...

Even the plain text menu bar [File Edit View Insert Format Tools Data Window
Help]?

That would be unusual, to say the least. If the menu bar is there, right
click on it. A drop down menu SHOULD appear. Click on Standard. The
Standard Bar should snap into place below the menu bar. Right click again
on the menu bar. Click on Formatting and the Formatting Bar should appear.
Be prudent, you can put enough bars up there to crowd the spreadsheet off
the screen (grin).

Finally go to the Tools menu on the menu bar, click and choose Options. On
the View tab click on the items you want to show at startup, Startup Task
Plane, Formula bar, Status bar, Windows in Taskbar. Choose other Window
options per your desires. Click on OK.
 
B

Blur

Ron de Bruin said:
Hi Littkerl

Do you see other toolbars on your screen ?

You can reset your menubar to default
Right click on a toolbar and choose customize

Under Toolbars select the worksheet menu bar
and click on reset

If not post back
Click to expand...
Hi Ron:

My Toolbar also disappeared. Only the formula bar is there. All the other
keys (like ALT F, ALT T.. etc do not work)

I followed your instructions above and it doesn't work bringing the tool bar
back either.

Can you help?

Cheers

soi
 
D

Dave Peterson

Try this:

open excel
hit alt-f11 (to get to the vbe)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").Enabled = true

Now back to excel and try
tools|customize|toolbars tab

You can select the standard, formatting (and more) toolbars and click reset.
 
B

Blur

Thanks Dave:

I followed your instructions and got following message:

Compile Error:

Expected: expression

and two buttons: OK and HELP
 
D

Dave Peterson

What point did you get that message?

And what did you type into the immediate window?
 
B

Blur

Thanks Dave:

I got the message when i hit ENTER after typing in the entire syntax u have
provided.

I thought i typed wrongly, so i did a COPY and PASTE, hit ENTER and still
get the same message.
 
D

Dave Peterson

It worked fine for me (multiple times).

I used this:

application.commandbars("worksheet menu bar").Enabled = true

and it worked lots of times.

=====
Another option is to kill all the toolbars and start over.

Close excel
windows start button|search|
look for *.xlb
(remember to look in hidden folders, too!)

If you want, rename all you find to *.xlbOLD (just in case).

Then restart excel.

If it worked ok, delete those *.xlbOLD files.

If it didn't work ok, close excel and rename them back to *.xlb (no harm, no
foul).


Thanks Dave:

I got the message when i hit ENTER after typing in the entire syntax u have
provided.

I thought i typed wrongly, so i did a COPY and PASTE, hit ENTER and still
get the same message.
Click to expand...
 
B

Blur

Many many thanks...the second option worked!

Dave Peterson said:
It worked fine for me (multiple times).

I used this:

application.commandbars("worksheet menu bar").Enabled = true

and it worked lots of times.

=====
Another option is to kill all the toolbars and start over.

Close excel
windows start button|search|
look for *.xlb
(remember to look in hidden folders, too!)

If you want, rename all you find to *.xlbOLD (just in case).

Then restart excel.

If it worked ok, delete those *.xlbOLD files.

If it didn't work ok, close excel and rename them back to *.xlb (no harm, no
foul).
Click to expand...
 
Top