Hi, everyone.
I'm using VBA to print excel workbook to pdf. Everything goes fine except that all the hyperlinks are gone. But there is this one workbook that when I print it, the hyperlinks are preserved. I tried to print it with sereval PDF printers, and got the same result - the hyperlinks are there. But no luck with other workbooks. It's really a myth to me cause it doesn't make sense. I tried to demystify this magic by myself but with no luck. Hopefully someone here can help me out. I believe there must be a rational explanation for this . Here I attached the workbook so you guys can analyze it.
My environment is Win7 RC(English version) + Office 2007 Home and Student(Chinese version, the interface is in English though which seems odd to me).