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

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