Embarressing Problem with Menus
 

Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my too
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried righ
clicking but no toolbar options come up. I can't even access th
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geof

--
Wyver
-----------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...nfo&userid=574
View this thread: http://www.excelforum.com/showthread.php?threadid=52345

Embarressing Problem with Menus
 

i think this was from don:



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

--


Gary


"Wyvern" wrote in message
...

Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my tool
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried right
clicking but no toolbar options come up. I can't even access the
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geoff


--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile:
http://www.excelforum.com/member.php...fo&userid=5743
View this thread: http://www.excelforum.com/showthread...hreadid=523455

Embarressing Problem with Menus
 

search your drive for your *.xlb file. This holds menu customizations. If
you don't have any customizations you want to retain, you can just close
excel, then delete this file and reopen.

If you do have customizations you want to retain, then that isn't an option.

--
Regards,
Tom Ogilvy


"Wyvern" wrote:


Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my tool
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried right
clicking but no toolbar options come up. I can't even access the
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geoff


--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...fo&userid=5743
View this thread: http://www.excelforum.com/showthread...hreadid=523455

Embarressing Problem with Menus
 

Awesome, thanks guys. I won't actually be able to try this until I ge
to work. But thanks for your responses, I'll let you know how I go.

Geof

--
Wyver
-----------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...nfo&userid=574
View this thread: http://www.excelforum.com/showthread.php?threadid=52345