I have a excel file with 2 worksheets.
The first worksheet is a list of hyperlinks to files (with a "friendly"
display name).
I want to create a cell in the second worksheet which uses data validation
to pick from the list of hyperlinks. I want the hyperlink on the second page
to be active so that users can click on it and go to the file. I also want
only the user "friendly" name to appear in the cell.
So far when I use data validation the link does not work and only the
"friendly" name appears as regular text in the cell.
Help!

Stacie,

I have the same issue, I you can find any workaround let me Know
please

Thanks


--
Ldery
------------------------------------------------------------------------
Ldery's Profile: http://www.excelforum.com/member.php...o&userid=29436
View this thread: http://www.excelforum.com/showthread...hreadid=491098