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

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

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

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