Hyperlink from within an Active Form?
Posted: Mon Jun 04, 2012 6:32 pm
I've built an active form containing a list of products. I'd like one of the columns to contain a hyperlink to a vendor's website.
So, I inserted a column in the active form having the Excel "hyperlink" formula. It references two columns (which will be hidden from the user), containing the URL and common name. When I build this formula in row 1 everything looks great-- the hyperlink changes to blue and is underlined. When I rebuild the sheet, however, the hyperlink reverts to plain text. I've played with the format section but to no avail.
This seems like it should be possible, shouldn't it? I've attached a values-only Excel file showing what I'm trying to do.
So, I inserted a column in the active form having the Excel "hyperlink" formula. It references two columns (which will be hidden from the user), containing the URL and common name. When I build this formula in row 1 everything looks great-- the hyperlink changes to blue and is underlined. When I rebuild the sheet, however, the hyperlink reverts to plain text. I've played with the format section but to no avail.
This seems like it should be possible, shouldn't it? I've attached a values-only Excel file showing what I'm trying to do.