P
penst8wx
I have an excel file that contains two images. These two images are dynamic
and are inserted to the file via the following code:
ActiveSheet.Shapes("Map").Select
Selection.Delete
ActiveSheet.Pictures.Insert(FullMapFileName).Select
With Selection
.Name = "Map"
.Top = Cells(12, 1).Top
.Left = Cells(12, 1).Left
.ShapeRange.ScaleWidth 0.77, msoFalse, msoScaleFromTopLeft
.ShapeRange.IncrementLeft 10
.ShapeRange.IncrementTop 3
End With
The images initially appear fine in the sheet, but when I go to print the
sheet, they print fine but they disappear on the screen. If I close the file
and reopen it the images are still there. Does anyone have any ideas what is
going on here. We have been using this spreadsheet in excel 2003 for several
years now with no problems. Are there problems with 2007 that would cause
this?
and are inserted to the file via the following code:
ActiveSheet.Shapes("Map").Select
Selection.Delete
ActiveSheet.Pictures.Insert(FullMapFileName).Select
With Selection
.Name = "Map"
.Top = Cells(12, 1).Top
.Left = Cells(12, 1).Left
.ShapeRange.ScaleWidth 0.77, msoFalse, msoScaleFromTopLeft
.ShapeRange.IncrementLeft 10
.ShapeRange.IncrementTop 3
End With
The images initially appear fine in the sheet, but when I go to print the
sheet, they print fine but they disappear on the screen. If I close the file
and reopen it the images are still there. Does anyone have any ideas what is
going on here. We have been using this spreadsheet in excel 2003 for several
years now with no problems. Are there problems with 2007 that would cause
this?