convert dynamic hyperlink (web) to static and print to pdf

i would like to export defined printing area to pdf format.
no sweat there. One problem i can't solve.
the sheet contains dynamic created hyperlinks (web).
when exporting or printing to pdf they become dead.
i can't seem to find a way to convert the dynamic hyperlink to static hyperlinks and still be usable in pdf .

hope anybody has a nice script.

what does this mean?

Originally Posted by The_Iceman

the sheet contains dynamic created hyperlinks (web).

and this?

Originally Posted by The_Iceman

when exporting or printing to pdf they become dead.

i've a sheet that has dynamic cells creating a hyperlink to search the web on the created value. the link works fine in Excel.


if printing to pdf the links don't work anymore.
using the Hyperlink function in excel is not dynamic.

Originally Posted by The_Iceman

if printing to pdf the links don't work anymore.

well of course they don't work anymore! ha ha ha. a PDF is a different document that an xlsx. it's impossible to transfer data like that from one program to another and via one file extension to another one because they are both written in different languages and the underlying architectural code for the 2 programs are completely different. Unless I'm mistaken, but I'm usually not.

see these:

https://en.wikipedia.org/wiki/PDF#Technical_foundations

https://www.google.com/search?q=ms+e...age+written+in