Delete Chart shortcut menu

[Avi]

Hello,

I try to disable the shortcut menu of an embedded chart with the following line:

Sub Menu()
CommandBars("Chart").Enabled = False
End Sub

I do not get any error message, but the shortcut menu is still there

Any help will be very appreciated

Avi
www.avibenita.com

 

[Bob Phillips]

Do you mean

CommandBars("Chart Type...").Enabled = False

instead?



--

HTH

RP
(remove nothere from the email address if mailing direct)


Hello,

I try to disable the shortcut menu of an embedded chart with the following line:

Sub Menu()
CommandBars("Chart").Enabled = False
End Sub

I do not get any error message, but the shortcut menu is still there

Any help will be very appreciated

Avi
www.avibenita.com