hyperlink validation list
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! |
hyperlink validation list
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 |
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com