No menus, no toolbars, no nothing!!
 

HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.

No menus, no toolbars, no nothing!!
 

Try this

hit alt-f11

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

then
tools|customize|toolbars tab


--
Don Guillett
SalesAid Software


"CR" wrote in message
ups.com...
HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.

No menus, no toolbars, no nothing!!
 

right click on a blank area of the Worksheet or formula bar and you should
see a list of toolbars. Select the ones you want to be visible.

also you can select customize, then in the first tab, select Worksheet Menu
Bar and click the reset button.

--
Regards,
Tom Ogilvy

"CR" wrote in message
ups.com...
HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.

No menus, no toolbars, no nothing!!
 

You're a life-saver. Thanks so much, Don! Have a great weekend.

No menus, no toolbars, no nothing!!
 

glad it helped


--
Don Guillett
SalesAid Software

"CR" wrote in message
oups.com...
You're a life-saver. Thanks so much, Don! Have a great weekend.