Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart object handles | Excel Discussion (Misc queries) | |||
Chart Sizing Handles | Charts and Charting in Excel | |||
Pie chart handles in the pivot table don't function | Charts and Charting in Excel | |||
Chart resizing handles | Charts and Charting in Excel | |||
select a chart without the selector handles showing? | Charts and Charting in Excel |