Disable Menu Items

[James]

I am currently using vba to disable menu items, using the
Application.CommandBars syntax, for example:
Application.CommandBars("Edit").Controls(2).Enabled = False
This is having an effect on all of Excel.
Is there a way I can disable it only for the Active Workbook.
I tried this:
ActiveWorkbook.CommandBars("Edit").Controls(2).Enabled = False
but I am getting an error "obejct variable not set" run time 91
Thanks

 

[Ron de Bruin]

hi James

See
http://www.rondebruin.nl/menuid.htm

Is there a way I can disable it only for the Active Workbook.

Read also this section
Other useful examples

 

[Gary Brown]

Put the disable command [Application.CommandBars("Edit").Controls(2).Enabled
= False] in the "Private Sub Workbook_Activate()" procedure of the
'ThisWorkbook' and the enable command
[Application.CommandBars("Edit").Controls(2).Enabled = True] in the "Private
Sub Workbook_Deactivate()" of the 'ThisWorkbook'.