VBA Determine which charts are selected

[cliffburton18]

Hi,

I have a macro which formats charts. It takes a user selected chart and formats it.

I would like to allow the user to select many charts and process them all at once (instead of just one at a time).

The problem is that when I have X charts selected in Excel, the Selection object assumes the "ChartObjects" type which includes all charts in the worksheet and not only those which are selected!
If I do "Selection.Count" it will count all charts (selected or not) and if I do "Selection.Item(x).Name" I can access any chart on the worksheet and not only those which are selected.

Questions:

1. Is there anyway to determine which charts are selected by the user? Either using the selection object or any other method?

2. When I select multiple objects (chart and non-charts), the selection object assumes the "DrawingObjects" type, which when counted returns the correct number of selected objects. However when I try to access them via "Selection.Item(x)" I again can access all DrawingObjects in the worksheet. Is there anyway to determine which drawing objects are selected? And access them (so I can determine whether they are charts)?

 

[Durka]

I ran into some difficulty with these solutions,

namely that the for each (variant) was rejected.

my solution was for each (ChartObject). I'm running Excel 2007