Murray,

If it was me, I think I'd have two custom menus - one for the Worksheet Menu
and one for the Chart Menu. Then you could put the chart-context button
just on the Chart Menu toolbar.

hth,

Doug

"Murray" <myall_blues@hotmail.com> wrote in message
news:1135294934.491542.303850@g49g2000cwa.googlegroups.com...
> Hello
>
> I have created a new menu (as per the many excellent examples that
> appear here) that will work via an add-in and adds a menu to both the
> Worksheet and Chart Menu bars.
>
> The menu has several items, but some are only applicable in a certain
> context. For example (and specifically) one of the items is only
> relevant if a chart is selected. Is it possible to have the menu item
> disabled (greyed-out) on both the Worksheet menu bar and the Chart menu
> bar, and only become active on the Chart menu bar when a chart is
> selected?
>
> eg:
> MenuItem1 - always active
> MenuItem2 - only active when a chart is selected
> MenuItem3 - always active
> etc...
>
> I assume that I need to tap into an event somehow (like activating a
> chart?) but don't know how to go about that. I'm still pretty much a
> neophyte with this stuff.
>
> Any suggestions would be very much appreciated.
>
> Thanks and regards
>
> Murray
>