Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
links
I have several invoices that I have scanned as .tif images. I would like to
be able to link to several of these files, but I only want to use one cell to do so. Is this possible? I would like to create a pull down list of the links to the files I want to hyperlink to, if it is even possible. Thanks in advance for any guidance. Kerry |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
links
In B1 thru B3 put the files ( with path):
C:\Documents and Settings\Owner\Local Settings\Temp\HisTempNowBehoHimAr.tif C:\Documents and Settings\Owner\Local Settings\Temp\LordGodWePraiYouArr.tif C:\Documents and Settings\Owner\Local Settings\Temp\LoveHasComeMelody.tif In A1 put a validation pull-down covering the list In A2 put: =HYPERLINK("file:///" & A1) So A1 pulls one of the .tif files and A2 make it "clickable" -- Gary''s Student - gsnu200798 "Kerry" wrote: I have several invoices that I have scanned as .tif images. I would like to be able to link to several of these files, but I only want to use one cell to do so. Is this possible? I would like to create a pull down list of the links to the files I want to hyperlink to, if it is even possible. Thanks in advance for any guidance. Kerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |