To make myself clear:

I would like to manually insert a picture-file-location to a cell.

That file should then be shown in three sheets at certain places.

I don't need the dropdown lists in this case, because the user will have to
put in a new picture every single time! I suppose, that it will make it all a
little easier, but your idea is great!!!

"Ron Coderre" skrev:

Download the ShowFilePicDemo file at this website:
http://www.contextures.com/excelfiles.html#CH0003

That file shows how to select an item from a DV dropdown list to have Excel
read a picture from a network or web server and paste it into the workbook.
I'm sure you could easily adjust the code to paste the picture into multiple
locations.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Aron" wrote in message
...
Hi!


I haven't found an answer on this question:

I would like to insert a photo by clicking in my worksheet. No problem.

My wish is, that the picture does not only appear there, but also two
other
places in the BIG worksheet. Is it possible and how to do it???


I have been thinking about making a macro, but it won't allow me to use
ANY
picture, but only the one I have chosen!

I hope I made myself clear, if not, just ask!

I would be happy to get some tips! I use Excel 2003!

Thanks in advance!

Best wishes
Aron