how to select multiple charts on a worksheet in excel 2007

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.
 
B

bmurphy

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
 
B

bmurphy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to select multiple charts on a worksheet in excel 2007 1
Multiple chart selection in Excel 2007 8
Excel 2007 Charts & Memory Leak?? 7
Controlling the number excel gives to charts 1
Print problems w/ charts excel 2003/2007 3
XL2007, Selection.Delete deletes more than the selection 5
Exporting charts outside excel 2
Copying charts to existing Worksheet 2

Top