Force PDF url opening without warning

[ViroMajor]

Hi,

I have this piece of code at the root of my sheet, whose aim is to open a URL, which actually is an online PDF

Please Login or Register  to view this content.

(I had to remove the link cause I don’t have the rights to post one)

Unfortunately, since it’s a PDF file, it triggers a popup that the source may be untrustworthy, asking to validate the action by hitting OK or cancel.

Would there be a piece of VBA code to bypass this warning message, and force the PDF opening right away ?
I need it to work on this link alone, and with any default browser.

Thanks for your time

[Haluk]

This works for me for a PDF file on my local PC.

Just change the path in the variable myURL to your real internet web URL and run the code to see if it works for you....

Please Login or Register  to view this content.

.