Hyperlinks

[Gerard Goodland]

Hi all,

I have a sheet with approx 100 rows. In Col F there is an alphanumeric
entry( 021RFF for example). On the hard drive there is a file with the
coresponding name ( C:Files\021RFF.xls). I want to get a hyperlink to
the value in the F col cells without having to manually add a hyperlink
in all rows.So would it be c:\Files\"F3".xls or what?

Thanks

 

[Don Guillett]

You could use a worksheet double click event and in it have the selected
cell tied into a follow hyperlink macro.