Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print preview moving pictures
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print preview moving pictures
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
why don't the pictures I add to excel 07 show on print preview? | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
How do I stop active x controls from moving after a print preview | Excel Discussion (Misc queries) |