|I did a bunch of Google searches and searches of other Excel related forums and all I can find are questions similar to yours, but no solutions. It appears that it just can't be done.|
I think I can sort of explain why it doesn't work. Perhaps you already figured this out, so bear with me. If nothing else, this explanation will be stored in the Archives in case someone else needs it.
When the Excel sheet is converted to a PDF, no hyperlinks are transferred to the PDF. Not the ones created with the HYPERLINK function, not the ones automatically created when you type a full URL into an Excel cell, and not the ones created via the Right-Click...Hyperlink feature. The only thing that is transferred to the PDF is the text that was in the cell.
However, similar to the automatic conversion that Excel does when it sees a properly formatted URL, the URL is converted to a hyperlink by the application that created the PDF.
You can prove this to yourself in this manner:
1 -Enter a full URL in an Excel cell - which Excel will automatically convert to a hyperlink.
2 - Right click the cell and choose "Remove Hyperlink". Now you don't have a hyperlink in the cell.
3 - Convert the Excel sheet to a PDF.
That non-hyperlink in the Excel sheet will now be a hyperlink in the PDF document.
In other words, Excel didn't transfer the hyperlink, the hyperlink was created within the PDF simply because the application saw the correct syntax of a hyperlink.
I hope that helps someone.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.