selecting multiple objects in Excel 2007

[Libby]

Hi there

I have been using Excel 2003 until recently and have recently had to try
Excel 2007

I have a worksheet with a chart on it and some labels. These labels contain
text referring to the chart and are changed by macros.
I have to sent this chart in a report and I do this by holding down shift
and clicking the chart and the labels to select them all before copying it as
a metafile into Word.

This process works fine in Excel 2003, but I've found that I'm unable to
select both the chart and the labels in Excel 2007 - When I click on the
chart the labels are deselected and vice versa.

Is there a way to do this in Excel 2007?

Many thanks in advance x

 

[Ron de Bruin]

There is no way to select all objects manual in 2007

I have more info here for delete code
http://www.rondebruin.nl/controlsobjectsworksheet.htm

 

[Libby]

Hi Ron,

Thanks for your reply.

That is very disappointing, though. Why would Microsoft remove such a
feature? The old adage "change to give the illusion of progress" comes to
mind.

 

[Earl Kiosterud]

"I got what I wanted, but I lost what I had."

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeyl.com
-----------------------------------------------------------------------