How do you keep the hyperlink URL active in a dropdown list. On one
worksheet I have the following in a cell
=HYPERLINK("[http://www.juniper.net/marketing/product_marketing/junos/docs/easy-to-learn-junos.pdf]JUNUS",
"JUNOS 101 White Paper") . I have named the 4 cells test. On another
worksheet in the workbook I created a validation list and enter the name
=test. But when I use the drop-down list ithe hyperlink function does not work