Disable pdf Hyperlink Warnings For Office 2016 programs
I have a macro that opens a hyperlink from a sheet and then downloads the file associated with that hyperlink. However, if the hyperlink is to a pdf file, I get a security warning message asking me if I would like to open the file. This negates the automatic process of the macro.
I've contacted support and they have stated that in Excel 2016 it is not possible to disable this warning message for a pdf file (however it is for other file types). I would like this feature added back in to Excel.
The community link further describing the issue can be found here: https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msowinother/how-to-disable-hyperlink-warnings-for-office-2016/95be3b0e-4a08-4092-ad8b-2ba105770e7a
D. J. CROWN commented
Genius guys from Microsoft, you need to put it back on. It is a pain you know where to get that annoying message for each hyperlink, it seems like a stupid competition with Acrobat to avoid PDF use. It makes no sense.
I am so confused because this was not happening to me before (Nov 2019) and now it is? What's going on?
Should also include older office versions, 2010 office has the same problem !!
Mike Crooks commented
I too want this fixed...not sure how we go about doing it...the message box popping up for pdf files is insane.