How to avoid pop up waning during file linking?

T

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,
 
T

timoti

mrice said:
Have you tried Application.DisplayAlerts = false in a start up macro?
Click to expand...


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
 
Top