View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DaveyJones DaveyJones is offline
external usenet poster
 
Posts: 44
Default 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