My excell tool bar / menu dissapeared and I can't get it back? any help?

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Littkerl" wrote in message ...
My excell tool bar / menu dissapeared and I can't get it back? any help?

"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl

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

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.



Blur wrote:

"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl

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

--

Dave Peterson

Thanks Dave:

I followed your instructions and got following message:

Compile Error:

Expected: expression

and two buttons: OK and HELP

"Dave Peterson" wrote:

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.



Blur wrote:

"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl

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

--

Dave Peterson

What point did you get that message?

And what did you type into the immediate window?



Blur wrote:

Thanks Dave:

I followed your instructions and got following message:

Compile Error:

Expected: expression

and two buttons: OK and HELP

"Dave Peterson" wrote:

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.



Blur wrote:

"Ron de Bruin" wrote:

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



--
Regards Ron de Bruin
http://www.rondebruin.nl

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

--

Dave Peterson


--

Dave Peterson

"Littkerl" wrote in message
...
My excell tool bar / menu dissapeared and I can't get it back? any help?

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.


--
Kent Finnell
From the Music City USA