Print preview moving pictures

  • Thread starter Thread starter Jonno
  • Start date Start date
J

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......
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Pictures 1
Printing multiple page wksht w/pictures 1
Objects & images move when viewing in print preview or printing. 2
Printing 36069 pages 1
My pictures appear to be hidden on my Excel spreadsheet. 2
Excel Borders not printing in Excel 8
Duplex Printing of Workbook with multiple worksheets 2

Back
Top