Just use something like:

Activesheet.Image3.Picture = Activesheet.Image2.Picture

I don't believe there is any link back to the original picture file (this
was used by loadpicture, but I don't see any property where it would be
retained).
--
Regards,
Tom Ogilvy


bdcrisp wrote in message
...
im using this to initially load all the pictures:

sheets(1).myimage.object.picture = _
LoadPicture("path etc .bmp")

however, when a user clicks on an image
im having this new image 'set' to "clicked image". then, when the user
clicks another image, it replaces with the image clicked first.. do you
understand?

i would like to say something like:
set oldObj = sheets(1).myoldimage
previousimage = oldObject.object.picture

set newObj = sheets(1).myimage
newObj.object.picture = _
LoadPicture(previousimage)

however.. here, the value of the previous image's .Picture is a long
integer.. not a path and filename.. i need to reference the image's
path and filename for this program


---
Message posted from http://www.ExcelForum.com/