How to avoid pop up waning during file linking?

[timoti]

Hi there,

when I program a link to a file , for example "file:///C:/test.log" in
the cell, I get an pop up warning "Hyperlinks can be harmful to your
computer and data.......". So everytime when I try to open the link, i
need to close all the pop up windows one by one.

Do you know how to avoid those windows popped up? thanks in advance :>







regards,

 

[mrice]

Have you tried Application.DisplayAlerts = false in a start up macro?

 

[timoti]

Have you tried Application.DisplayAlerts = false in a start up macro?

mrice,

thanks for you reply.
i'm not really familiar with VBA programming. I tried to add in th
following function but the warning still pop up.

Private Sub Workbook_Open()
Application.DisplayAlerts = False
End Su