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

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"James" <(E-Mail Removed)> wrote in message
news:A2B0733A-8C07-4EA7-BF07-(E-Mail Removed)...
>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

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'.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"James" wrote:

> 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