Linking to Graphics

[scw1217]

Is there a way in Excel 2003 to link column text to a .jpg photograph o
my computer? I have to track inventory and would like to be able to se
the object in question. If not, what options are available. I am ne
to 2003 and have only used 97. Thanks

 

[Dave Peterson]

Maybe you could just hyperlink to that file.

=hyperlink("File:////c:/pictures/pict1.jpg")

 

[scw1217]

Thanks. I did that and it worked. :

 

[Guest]

Would this work if the pictures are all in the same file but on another
worksheet? They wouldn't have different names. I was trying access them
using cell references when they were selected with a drop down box.

Maybe you could just hyperlink to that file.

=hyperlink("File:////c:/pictures/pict1.jpg")

 

[Dave Peterson]

How about if you just hyperlinked a cell under the picture on that other
worksheet:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Would this work if the pictures are all in the same file but on another
worksheet? They wouldn't have different names. I was trying access them
using cell references when they were selected with a drop down box.

 

[Guest]

Would that take me to the page with the graphics? I need for the graphic to
come back to the 'front' page.

How about if you just hyperlinked a cell under the picture on that other
worksheet:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

 

[Dave Peterson]

Yes. That would go to the graphic. That's what hyperlinks do.

You may be able to use a different technique.

J.E. McGimpsey has a routine that hides/unhides pictures based on the value of a
cell.
http://www.mcgimpsey.com/excel/lookuppics.html

Would that take me to the page with the graphics? I need for the graphic to
come back to the 'front' page.