Chart Objects

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