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