Copy shapes in excel 2007

**bvdven** · 02-24-2010, 01:12 PM

Hello,
In Excel 2003 I used to copy Shapes just by selecting a cell on which the shape was positioned. In Excel 2007 this does not function any more; I am only able to copy a shape after selecting the shape itsself.
Not a real problem of course in normal life, but the copy functionality is built into VBA.

Any trick to regain this copy shapes by selecting a cell?

regards,
Bart

**Huron** · 02-24-2010, 02:59 PM

Go to Excel Options - Advanced then check "Cut, copy and sort inserted objects with their parent cells"

**bvdven** · 02-25-2010, 04:20 AM

Thanks, but .....
"Cut, copy ....." was already checked.
Unchecking it does not solve my problem.

Any other idea?

**Andy Pope** · 02-25-2010, 07:28 AM

You need the setting Huron suggested.
You also need the shape to be completely with in the range being copied.

Can you post example of a workbook where the copy does not work for you.