assigning a macro to chart

[Claude]

Hi all
I have assigned a macro to a chart, (i.e. code executes
when chart is clicked)and would like to refer back to the
chart that has just been clicked, similar to referring
to "ActiveChart", except that in this case the click does
not activate the chart. Is this possible, or does one have
to assign an individual macro to every chart (and refer to
the specific chart)?

 

[Jon Peltier]

Claude -

Application.Caller, in the called macro, tells you the name of the chart
object. So refer to the chart using
activesheet.ChartObjects(Application.Caller)

- Jon