If I hold down the shift key and click on some, but not all, of the
embedded charts on a worksheet, and go the VBA and do
Selection.Delete, ALL the charts are deleted.

I am using xl2007SP1

Can anyone else confirm this behavior?

In any earlier excel version, of course, only the selected charts are
deleted.

Is this a known problem with Excel 2007? If so, I think it's a
serious one.

Brian Murphy

Hi Brian -

Consider it confirmed. I have routines that work only on the selected charts
on a worksheet, but if there are multiple charts, and I select more than
one, then all charts are processed. VBA apparently cannot distinguish
unselected from selected charts in 2007.

The workaround is that, if I also select a drawing object (a shape), my
routines can once again distinguish between selected and unselected charts.
However, I haven't figured out programmatically how to add a shape to the
selected items, without the selection picking up the unselected charts.

I think I've reported this as a bug. I'll check, and if I haven't I will do
so.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"xlrotor" wrote in message
...
If I hold down the shift key and click on some, but not all, of the
embedded charts on a worksheet, and go the VBA and do
Selection.Delete, ALL the charts are deleted.

I am using xl2007SP1

Can anyone else confirm this behavior?

In any earlier excel version, of course, only the selected charts are
deleted.

Is this a known problem with Excel 2007? If so, I think it's a
serious one.

Brian Murphy

Thank you for the conformation, John.

It's good that it's not something I was doing wrong, but bad that
Excel 2007 has such a serious problem.

By the way, my own list of excel 2007 VBA glitches and workarounds
might be useful to others. Is there a publicly accessible list like
this anywhere?

Brian

Brian -

I don't know of such a list, but if you forward it to me, I can add my
stuff, forward it to the authorities, and post a copy.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"xlrotor" wrote in message
...
Thank you for the conformation, John.

It's good that it's not something I was doing wrong, but bad that
Excel 2007 has such a serious problem.

By the way, my own list of excel 2007 VBA glitches and workarounds
might be useful to others. Is there a publicly accessible list like
this anywhere?

Brian

I'll work on my list.

My current wrestling match with xl2007 over is custom placement of
chart point DataLabels. It's soooooo sloooowwwww. But I've still got
ideas to try, yet.

Brian

Too bad we have to try so many new ideas to make it work the way it used to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"xlrotor" wrote in message
...
I'll work on my list.

My current wrestling match with xl2007 over is custom placement of
chart point DataLabels. It's soooooo sloooowwwww. But I've still got
ideas to try, yet.

Brian