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,


--
timoti
------------------------------------------------------------------------
timoti's Profile: http://www.excelforum.com/member.php...o&userid=34326
View this thread: http://www.excelforum.com/showthread...hreadid=540915

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=540915

mrice Wrote:
> 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

--
timot
-----------------------------------------------------------------------
timoti's Profile: http://www.excelforum.com/member.php...fo&userid=3432
View this thread: http://www.excelforum.com/showthread.php?threadid=54091