Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You're a life-saver. Thanks so much, Don! Have a great weekend.
|
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Menus and Toolbars | Excel Discussion (Misc queries) | |||
Cannot unhide toolbars/menus | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) | |||
ToolBars and Custom Menus | Excel Programming | |||
Restricting use of menus and toolbars | Excel Programming |