Refer to Clicked Object

[dioenigma]

I am assigning a macro to a chart - I originally had written is so that a series of actions would be performed on the Active object. Unfortunately I did not realize that once the macro was assigned to the chart, clicking on the chart would activate the macro, but would not select the chart, therefore rendering the entire macro obsolete. Any workaround for this? Thanks!

 

[Ivan F Moala]

if you are selecting the Chart then try something like

    ActiveSheet.Shapes(Application.Caller).Select

generally not good to select objects... but try this any way