Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Menu Dissapeared
I lost my main menu and only have my toolbars left
visible. I created a custom menu items but I did it in VBA so I can just re-run the macro. I just need to get the default menu back. I lost it by running this: Sub test() Set myMenuBar = CommandBars.ActiveMenuBar With myMenuBar.Enabled = False End With End Sub I tried to change Enabled to True but it didn't work. I'm on Excel XP. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Menu Dissapeared
CommandBars("Worksheet Menu Bar").Enabled = True
-- Regards, Tom Ogilvy "dan" wrote in message ... I lost my main menu and only have my toolbars left visible. I created a custom menu items but I did it in VBA so I can just re-run the macro. I just need to get the default menu back. I lost it by running this: Sub test() Set myMenuBar = CommandBars.ActiveMenuBar With myMenuBar.Enabled = False End With End Sub I tried to change Enabled to True but it didn't work. I'm on Excel XP. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Menu Dissapeared
Right on worked in a second, Thanks alot!
-----Original Message----- CommandBars("Worksheet Menu Bar").Enabled = True -- Regards, Tom Ogilvy "dan" wrote in message ... I lost my main menu and only have my toolbars left visible. I created a custom menu items but I did it in VBA so I can just re-run the macro. I just need to get the default menu back. I lost it by running this: Sub test() Set myMenuBar = CommandBars.ActiveMenuBar With myMenuBar.Enabled = False End With End Sub I tried to change Enabled to True but it didn't work. I'm on Excel XP. Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Excel -My paste menu is not the norm. The menu is different. | Setting up and Configuration of Excel | |||
Fill & Font colours have dissapeared | Excel Discussion (Misc queries) | |||
My Excel menu bar has dissapeared | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |