View Single Post
  #4   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

Yes; e.g.:

CommandBars("Insert").Controls("Name").Controls("D efine...").Enabled = False

--

Vasant

"Dusan" <a@a wrote in message
...
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" <vasantn *AT* aol *DOT* com wrote in message
...
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