View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Disabling standart menu options

CommandBars("Worksheet Menu Bar').Enabled = False 'True

--

Vasant

"Dusan" <a@a wrote in message
...
Hello,

Is there any way to disable the standard excel menu options.
I managed to create own custom menu but I'd like hide the others

I know how to create/add new menu items but don't know how to get rid of
the standard ones.
When closing the worksheet the standrd menu should be restored.


Thanks for your help,
Dusan