ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disappearing Images (https://www.excelbanter.com/excel-programming/407452-disappearing-images.html)

penst8wx

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?



All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com