View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
penst8wx penst8wx is offline
external usenet poster
 
Posts: 1
Default Disappearing Images

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).Selec t
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?