Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Menus - 2nd Problem | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Problem with IE menus after installing excel macros | Excel Programming | |||
Overriding Actions of Excel DropDown Menus and Poup Menus | Excel Programming |