Disabling standart menu options

[Dusan]

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

 

[Vasant Nanavati]

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

 

[Dusan]

But is it possible to disable just some menu options like "File", "Windows"?
I'd like to keep the meno bar but wont to remove some menu options.

Cheers
Dusan

 

[Vasant Nanavati]

Yes; e.g.:

CommandBars("Insert").Controls("Name").Controls("Define...").Enabled = False