Thanks for putting that up, though my take is slightly different in one or
two areas.

I don't think there's anything wrong with that four cornered halo selection,
ie a single chartobject. You can get that, as you say, by holding Ctrl and
clicking on the chart. Or, in code by doing say
ActiveSheet.DrawingObjects(1).Select
? typename(selection) ' ChartObject

What seems odd to me is we don't get that apparent selection, the halos,
when multiple chartobjects are selected.

Start again, assuming the only shapes on the sheet are chartobjects do

ActiveSheet.DrawingObjects.Select '
' in earlier versions .ChartObjects.Select

This should select all chartobjects. But intermittently it might not or
might not, and if not thereafter no way to select multiple charts, manually
or programmatically without starting afresh (eg select cells).

Holding Shift doesn't seem to make any difference for me either way (as you
suggest in the pdf)

Jon - do you really never see the chartobject like selection handles
(halos), like the second chart in Brian's pdf.

Regards,
Peter T


"Brian Murphy" wrote in message
...
Oops. There was a typing error in the URL. This one should work.

http://www.xlrotor.com/temp/Selectin...ple_charts.pdf

Brian