Is there a way you can get Excel to change an image in a cell
"A hyperlink is a link from a document that opens another page or file when
you click it. The destination is frequently another Web page, but it can also
be a picture, or an e-mail address, or a program. The hyperlink itself can be
text or a picture."
--
paul
remove nospam for email addy!
"barry24uk" wrote:
Using a Hyperlink will not work. Hyperlinks will take you to a place that you
link to same as it does on a webpage.
"paul" wrote:
hyperlinks
--
paul
remove nospam for email addy!
"barry24uk" wrote:
K. I will try and explain this the best I can.
I am creating a database based on ships.
I have around 50 thumbsized images and I have resized a cell to fit these
images in the main page that gives information about each ship.
I need this cell to be able to change the image each time the name of the
ship changes.
I can't store these images on my HD and link to them as other people useing
the database would have to have the same images as well.
I would like to paste all the images into a seperate sheet in the workbook.
The only way I can think of doing this would be to lock an image to a cell
and then use something like VLOOKUP but I can't find a function that allows
you to lock an image to a cell.
Any help on this would be apreciated.
Thank you.
|