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.

What are you trying?

" wrote:

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




On Aug 25, 1:22 pm, Barb Reinhardt
wrote:
What are you trying?

" wrote:
Inexcel2007, 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 toexcel2007do 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 theexcel.charts newsgroup.
It wasn't intentional cross-posting.

I'm sorry, I can't help with this one as I don't have 2007.

" wrote:

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




On Aug 25, 1:22 pm, Barb Reinhardt
wrote:
What are you trying?

" wrote:
Inexcel2007, 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 toexcel2007do 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 theexcel.charts newsgroup.
It wasn't intentional cross-posting.

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



On Aug 27, 10:26 am, Barb Reinhardt
wrote:
I'm sorry, I can't help with this one as I don't have2007.

" wrote:
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 toExcel2007. Use the shift key to
select the desired charts, and in VBA the Selection object was a
collection of those charts.

Brian

On Aug 25, 1:22 pm, Barb Reinhardt
wrote:
What are you trying?

" wrote:
Inexcel2007, 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 toexcel2007do 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 theexcel.charts newsgroup.
It wasn't intentional cross-posting.