Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
Insert same picture in multiple sheets and only change once | Excel Discussion (Misc queries) | |||
How to insert picture and automatically size to cell? | Excel Worksheet Functions | |||
How to insert a picture that automatically sizes to size of cell? | Excel Worksheet Functions |