Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent: Enable All of the excel command bar
I met a big problem. My Excel lost all of the command bars. When I open any
Excel file now, the menu bar are gray except "File" "Edit", even most of the sub buttons on "File" and "Edit" are gray. Together with Right Click! How to Enable my bars? How to ACTIVATE my Excel? I have try to do it in VBA: Application.CommandBars("Worksheet Menu Bar").Enabled = True, no reply. I need your help urgently! Thanks, Viesta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent: Enable All of the excel command bar
Don't know that much but it sounds like your sheets/spreadheet is protected.
Just unprotect the sheet and it will let you use the command bars again... -- Dave "ViestaWu" wrote: I met a big problem. My Excel lost all of the command bars. When I open any Excel file now, the menu bar are gray except "File" "Edit", even most of the sub buttons on "File" and "Edit" are gray. Together with Right Click! How to Enable my bars? How to ACTIVATE my Excel? I have try to do it in VBA: Application.CommandBars("Worksheet Menu Bar").Enabled = True, no reply. I need your help urgently! Thanks, Viesta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN | Excel Discussion (Misc queries) | |||
Enable Command Button Procedure | Excel Discussion (Misc queries) | |||
trying to enable top level command bars by context | Excel Programming | |||
enable menu command not working | Excel Programming | |||
Enable Command Button 1 & 2 | Excel Programming |