Selective Link to Picture

M

mloffler

I want to show a linked (not embedded) picture based on entry in a
cell.
This way, I can keep the excel spreadsheet light.

Any help?
 
D

Dave Peterson

Insert|Hyperlink
and point to your picture file

or use the worksheet =hyperlink() worksheet function:
=HYPERLINK("file:////c:/my pictures/myfolder/somepict.jpg")

I think if you use the =hyperlink() worksheet function, your workbook will be
"lighter".
 
E

Earl Kiosterud

Dave,

When the OP said he wanted linked, not embedded, I got the impression that he wants the
picture to show in the worksheet, but not be included in the workbook file, rather linked to
a stored image file. I don't know any way to do that outside of using a macro. Your
hyperlink solution will require clicking the hyperlink, and will launch some application to
display the image, outside of Excel. I think.

That's my story, but I might not stick to it! :)
 
D

Dave Peterson

Could be...

But when I read that the OP wanted it light, I guessed that he really meant
hyperlinked to the document--so that the workbook doesn't get weighed down with
the actual pictures.

But I've been wrong before!
 
M

Marty

Could be...

But when I read that the OP wanted it light, I guessed that he really meant
hyperlinked to the document--so that the workbook doesn't get weighed down with
the actual pictures.

But I've been wrong before!









--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

I will give an example:
In a drop-down menu, I will have engines. Everytime an engine is
selected, I want a corresponding picture to show up beside it.

I have gotten close by inserting the picture as an object, with linked
to file selected.
Then, the image place holder is shown. (When you click on it, it
shows the link to the picture in the formula bar.)
I right-click on the placeholder and choose Package Object/Edit
Package on the menu.
Next, I open the same picture in MS Photo Editor and then copy the
image to the clipboard.
I go back to the Object Packager window and click on the left hand
side (to make it active).
I then paste the image into the left hand side which is call the
Appearance.
Then, File/Update in the menu, then File/Exit.
Now I have a linked picture. (Maybe I have also embedded following
this process).

I set up a table with three columns:
1: Engine 2: Offset number (row number in the table with first one
being 0) 3. the linked object as created above

Then create a vlookup to look up the menu choice made to return its
corresponding offset number.

Then I create a range name called "Engine." I make its formula:
=OFFSET(reference,rows,cols,height,width)
reference is equal to the the top left hand cell of the table.
rows is equal to the cell returning the offset position (created
by the vlookup)
columns is equal to 2 (means 2 columns to the right)
height is equal to 1
row is equal to 1

Next, I activate the Camera button by customizing the excel menu bar.
I use the camera button to create a box.
While the picture window is active, i click on the formula bar and
type =Engine
This make the picture content equal to the range name which is
pointing to the cell for the picture which corresponds to the
selection made in a menu.

I think this is working however seems messy. Hyperlinks have not
worked. Like I said, because i am changing the Appearance of the
linked object, I may be making the file heavier anyways. I want to
avoid embedding pictures as I have hundreds of pictures I would like
to link.
 
Top