|
-
Jul 25th, 2013, 04:04 PM
#1
Thread Starter
Addicted Member
Shapes resized after pasting
I have a macro that selects an array of shapes, copies them and then pastes them in another sheet.
The source of the shapes varies but I always take care of removing properties like "move and resize".
Something that is happening lately is that some of the shapes get pasted and reshaped on one axis. More precisely it gets scaled to 1%. This doesn't affect all the shapes of the array.
Does anyone has a clue on this bug? Thanks!
-
Jul 25th, 2013, 06:42 PM
#2
Thread Starter
Addicted Member
Re: Shapes resized after pasting
I think I have a solution but I don't know how to implement it.
The factor from ScaleHeight is intact, the only one affected is the the factor from ScaleWidth. Since these are methods and not properties I can't retrieve them so that I add a loop that does something like:
<code>For each shp in sht.Shapes
shp.ScaleWidth.Factor=shp.ScaleHeight.Factor
Next shp</code>
Thoughts?
-
Jul 26th, 2013, 08:24 AM
#3
Re: Shapes resized after pasting
Would like to see your code that's doing the copying and pasting.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|