Hi,
I am creating a shape and want to use an image as its background. I have discovered the UserPicture attribute, but I suspect that can only refer to a file on an external filesystem. I want my spreadsheet to be totally portable.
Is it possible to set the shape background to be another object already in the workbook?
This works...
Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, _
0#, 0#, 54, 14)
shp.Fill.UserPicture "W:\Spreadsheets\background.bmp"
This doesn't work. Why?
Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, _
0#, 0#, 54, 14)
shp.Fill.UserPicture Sheets("Data").Shapes("Picture1")
Thanks,
Justin
I am creating a shape and want to use an image as its background. I have discovered the UserPicture attribute, but I suspect that can only refer to a file on an external filesystem. I want my spreadsheet to be totally portable.
Is it possible to set the shape background to be another object already in the workbook?
This works...
Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, _
0#, 0#, 54, 14)
shp.Fill.UserPicture "W:\Spreadsheets\background.bmp"
This doesn't work. Why?
Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, _
0#, 0#, 54, 14)
shp.Fill.UserPicture Sheets("Data").Shapes("Picture1")
Thanks,
Justin