XL2007, Selection.Delete deletes more than the selection

[xlrotor]

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

 

[Jon Peltier]

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

 

[xlrotor]

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

 

[Jon Peltier]

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

 

[xlrotor]

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

 

[Jon Peltier]

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

- Jon