Hello,
I have two charts embedded on a worksheet, that I have named ChartA and
ChartB. How can I tell which chart object has been selected by a user? For
example, if a person selects a point on ChartA, I want to run some code to
format that point.

Thanks.

bill

Hi,

How about Activechart.Parent.Name , which should return either ChartA or
ChartB.

Cheers
Andy

Bill wrote:
Hello,
I have two charts embedded on a worksheet, that I have named ChartA and
ChartB. How can I tell which chart object has been selected by a user? For
example, if a person selects a point on ChartA, I want to run some code to
format that point.

Thanks.

bill



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info