linking jpeg files
 

I am trying to create an internal link for a jpeg file in excel. What I want
to do is create a link in a cell that can access a jpeg file that is being
stored within the workbook. Is this possible.

linking jpeg files
 

Just set the hyperlink to a cell at the top of the jpeg picture.
--
Gary''s Student - gsnu200762


"Mike" wrote:

I am trying to create an internal link for a jpeg file in excel. What I want
to do is create a link in a cell that can access a jpeg file that is being
stored within the workbook. Is this possible.

linking jpeg files
 

Mike

Have a look at a these couple of solutions.

Note: in both cases the jpgs must be stored on the same worksheet you are
calling from.

To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed.

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP


On Wed, 26 Dec 2007 13:31:01 -0800, Mike wrote:

I am trying to create an internal link for a jpeg file in excel. What I want
to do is create a link in a cell that can access a jpeg file that is being
stored within the workbook. Is this possible.