Disabling standart menu options

  • Thread starter Thread starter Dusan
  • Start date Start date
D

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
 
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
 
Yes; e.g.:

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