How Do I save a Camera Icon Dynamic Picture Link created in the Sheet itself?

How Do I save a Camera Icon Dynamic Picture Link created in the Sheet itself?

Using the Camera Icon one can create a Images or Picture Links to the origjnal set of cells, now this Image or Picture is created in the Excel Sheet itself, now how Do i save this image to use it elsewhere?

Ex: Lets say I have 2 scenarios
1 Scenario: I have a rnage of numeric values in the range from A1 till C3 with the formula as = RAND()*100...

As the RAND function is used the value keeps on changing everytime I press F9..

Now using the Camera ICon I select the range of cells and paste it next to the OriginalRange as an Picture Link now true to its LINKING property it keeps on showing different values..


2.Scenario I have a Dynamic Picture in the cell A1 with some text at the Bottom of the Picture in the same cell i.e the Picture occupies the TOP portion and in the same cell at the bottome theres some space left intentionally left behind to show the TEXT alongwith the Image..

NOW on USING THE Camera ICon for the above 2 Scenarios I need to get the method to save the Dynamic Images..

Is this possiible and if yes then please provide an example..

Warm Regards
e4excel

Hey MarvinP,

Thanks for the File its indeed very good and compact but unfortunately thats not what I want, I want to use the Images created by the USer in the Sheet like the Selection of Data from cells A1 till C3 withe Camera Icon becomes a Dynamic Picture evertytime we pres F(..

Similarly just consider that the Pictures which you are making Visible on the event of the the numbers between 1 and 4..

if the Images was to be placed just above the Text as shown in my file and I would select this cell with the TEXT at the bottom of the cell and the pciture OVerlaying over the TEXT then this would be a new Image for me everytime the user presses F9 or theres a calculation of any sort..


So how would I be able to save this everchanging Image which will change every now and then when the Function key F9 is pressed.

But I liked your file too which has some very cute pics..
Basically I am trying to have a mechanism where I am able to save the Picture Link Images temporaritly till the time for the next change.

Warm Regards
e4excel

Dear MarvinP,

Please look at the link which is what I am intending to save..

http://www.techrepublic.com/blog/mso...xcel-data/1438

Now, if this image can be saved which is linked to several range of cells and which change on certain conditions then it becomes Dynamic Image..

If I am able to save this Image somehow then I Can use it further..

Warm Regards
e4excel