Which event puts *white* handles around a chart?
 

Hi folks,

Excel 97. A worksheet with an embedded chart. I have a class module
set up to enable events for the embedded chart. I can handle normal
events just fine. When I click on the chart I get the expected
Chart_Activate, Chart_Select, Chart_MouseDown, etc. So far so good.

When I start by holding down Ctrl or Shift and then click on the
chart, I get selection handles (white squares) around the chart.
That's fine, but which event can trap this? It's not any of the Chart
events and it's not the Worksheet_SelectionChange event. When the
white handles are showing, "?TypeName(Application.Selection)" yields
"ChartObject". I tried setting up a class module for Application
level events and it's none of those either.

So just which event fires for "white" squares around the chart as
opposed to "black" (Activate) squares?

Thanks,

Dan

Which event puts *white* handles around a chart?
 

Dan,

Embedded charts are contained within ChartObjects, as you have found. If you take a look at the ChartObject object in the Object
Browser you will see that it does not expose any events.

If you are trying to prevent users selecting the chartobjects, you could protect the worksheet.

--

John Green - Excel MVP
Sydney
Australia


"Dan" wrote in message om...
Hi folks,

Excel 97. A worksheet with an embedded chart. I have a class module
set up to enable events for the embedded chart. I can handle normal
events just fine. When I click on the chart I get the expected
Chart_Activate, Chart_Select, Chart_MouseDown, etc. So far so good.

When I start by holding down Ctrl or Shift and then click on the
chart, I get selection handles (white squares) around the chart.
That's fine, but which event can trap this? It's not any of the Chart
events and it's not the Worksheet_SelectionChange event. When the
white handles are showing, "?TypeName(Application.Selection)" yields
"ChartObject". I tried setting up a class module for Application
level events and it's none of those either.

So just which event fires for "white" squares around the chart as
opposed to "black" (Activate) squares?

Thanks,

Dan