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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jonno" wrote in message
...
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......
--
Jonno