Excel 2010 - resize multiple linked images to be the same size

[InvGrp2]

I've created several linked pictures and but I can't figure out how to make all of them the same size (they're calendars)....I was able to align them but no luck in resizing them to be the same size.

Is this possible?

Thanks.

Bruce

P.S. excel 2010, win7 pro

[dflak]

The part of the code highlighted in red should clear out the old data before copying. Put in the part in green and then try it. You will get a box that pops up telling you that this part of the code is running. If that doesn't happen then something else is wrong.

[cod]
Sub CopyReport()
Dim shS As Worksheet ' Source Sheet
Dim shD As Worksheet ' Destination Sheet
Dim cl As Range ' Cell pointer for map table
Dim shp As Shape ' Generic shape

Dim SSheet As String ' Source Sheet Name
Dim MyObj As String ' The object (range or chart) to be copied
Dim MyType As String ' The type of the object (range or chart)
Dim DSheet As String ' Destination Sheet Name
Dim MyTop As Double ' Object top
Dim MyLeft As Double ' Object left
Dim MyWidth As Double ' Object width
Dim MyHeight As Double ' Object type

' Set the destination sheet
Set shD = Sheets("Report Sheet")

Application.ScreenUpdating = False

msgbox "Copying Report"

ClearPivot

' Clear out destination worksheet
For Each shp In shD.Shapes
shp.Delete
Next

' Read Map and copy
For Each cl In Range("Table_Map[Source Sheet]")
[/code]

[dflak]

Try this version.

[InvGrp2]

Thanks for responding but I have no idea how these apply to my issue.

Was your response directed to re-sizing some linked pictures (calendars) or was it meant for someone else.

Bruce

[dflak]

Yes, this was added to the wrong window. My apologies for the confusion.

[InvGrp2]

No problem.

[dflak]

I will make you an offer. If you attach a sample workbook, I can probably help you. I've done this kind of thing before.

[InvGrp2]

I appreciate the offer but fortunately, I figured it out last night.

I didn't realize there was a drop down window under "picture tools" under size.

The problem was the "aspect ratio" was locked and once that was unchecked I was able to select all pictures and make them the same size.

Thanks again.