Print preview moving pictures

[Jonno]

Hi,

Am using excell 2007 and i have a worksheet which has pictures in.

When i go to print preview or print the worksheet off the pictures have
moved from there position and are now in the middle of my calculations?

I have opened the same worksheet in 2003 and this problem does not occur.

Is there anyway around this??????

Thanks in advance......

 

[Don Guillett]

You need to change the properties of the shape to NOT move, either manually
or use this macro.

Sub dontmoveshapes1()
For Each sh In ActiveSheet.Shapes
sh.Select
Selection.ShapeRange.SetShapesDefaultProperties
Selection.Placement = xlFreeFloating
Next
End Sub