How to stop the popup warning window when clicking on a hyperlink

[pschurb]

I am automating Excel by linking to batch files and log files on my computer
using the =hyperlinks() worksheet function. How can I stop the Microsoft
Office warning window that contains the message "Some files can contain
viruses ..." "Would you like to open this file?" < OK> <Cancel>; when I
click on a hyperlink?
"Application.DisplayAlerts = False" does not prevent this popup window from
appearing.

[Jim Thomlinson]

You can't. If you could then a virus would just disable the warning.
--
HTH...

Jim Thomlinson


"pschurb" wrote:

> I am automating Excel by linking to batch files and log files on my computer
> using the =hyperlinks() worksheet function. How can I stop the Microsoft
> Office warning window that contains the message "Some files can contain
> viruses ..." "Would you like to open this file?" < OK> <Cancel>; when I
> click on a hyperlink?
> "Application.DisplayAlerts = False" does not prevent this popup window from
> appearing.
>