I have a worksheet with a hyperlink to a program outside Excel. This is
working fine at this point with one exception. Every time you click on
the link Excel puts up a message box stating the following:

€œSome files can contain viruses or otherwise be harmful to your
computer. It is important to be certain that this file is from a
trustworthy source.

Would you like to open this file?€�

This is really irritating , as it pops up every time. How can I stop it
popping up?

I looked on the net and somebody suggested this might work :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = True
End Sub

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

The problem is that i would have no idea where to place this , or enact
it , in Excel. Can someone help?


Thanks