how to select multiple charts on a worksheet in excel 2007

  • Thread starter Thread starter bmurphy
  • Start date Start date
B

bmurphy

In excel 2007, how does one select a subset of charts on a worksheet,
and then in a macro loop through the selected charts.

The methods that worked prior to excel 2007 do not work. I cannot
figure out how to use the mouse to select the charts, and then in a
macro loop through the selected charts.

Does anyone know how to do this?

Thanks,

Brian Murphy
Austin, TX

ps: I accidentally posted this first in the excel.charts newsgroup.
It wasn't intentional cross-posting.
 
I've tried selecting the charts with different combinations of shift,
control, alternate keys held down. Then in VBA check to see if the
Selection object is a collection of the chart objects I selected.

In all my attempts, the Selection is of ALL the charts on the
worksheet even when only some of them are selected.

So I'm hoping there is some way to tell which charts have been
selected.

This was all very simple prior to Excel 2007. Use the shift key to
select the desired charts, and in VBA the Selection object was a
collection of those charts.

Brian
 
I now know via Jon Peltier that this has been reported as a bug.

I sure hope MS fixes it soon. I have a lot of macros that need to be
able to operate on a selected subset of charts.

Brian
 
Back
Top