selecting multiple objects in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Libby - 07 Feb 2008 17:52 GMT

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

Reply to this Message

Ron de Bruin - 07 Feb 2008 20:18 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi there
>
[quoted text clipped - 14 lines]
>
> Many thanks in advance x

Reply to this Message

Libby - 07 Feb 2008 23:54 GMT

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.

> There is no way to select all objects manual in 2007
>
[quoted text clipped - 19 lines]
> >
> > Many thanks in advance x

Reply to this Message

Earl Kiosterud - 08 Feb 2008 01:22 GMT

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

Signature

Regards from Virginia Beach,

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

> Hi Ron,
>
[quoted text clipped - 27 lines]
>> >
>> > Many thanks in advance x

Reply to this Message