Insert picture and let it automatically be copied to other sheets
 

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

Insert picture and let it automatically be copied to other sheets
 

BUMP


Can't anybody help me???

Is it possible or what do you think???

"Aron" skrev:

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

Insert picture and let it automatically be copied to other sheets
 

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

Insert picture and let it automatically be copied to other she
 

"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

Insert picture and let it automatically be copied to other she
 

Hey Ron!

And thanks for your answer.

It looks very good and professional. Unfortunately I'm not sure how to
implement it into my sheet(s).

I would like to have a code, where I just change the cells etc. and then it
would work. I can use macros and programme some easy, but I can't "write"
them myself.

I will go on with trying now;)


"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

Insert picture and let it automatically be copied to other she
 

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