How to turn off the popup warning when clicking on a hyperlink
 

I am automating Excel by linking to batch files and log files on my computer
using the =hyperlink() 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?

How to turn off the popup warning when clicking on a hyperlink
 

try
application.displayalerts=false
'your code
application.displayalerts=true


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539387

How to turn off the popup warning when clicking on a hyperlink
 

davesexcel:

Many thanks for your answer to my question. I tryed the displayalerts code
and I still get the popup window. I was given the following answer in
another section of the Excel forum by " garfield-n-odie [MVP] "

See http://support.microsoft.com/?kbid=829072 "How to disable
hyperlink warning messages in Office 2003".

Best Regards and thanks again for your answer!
pschurb


"davesexcel" wrote:


try
application.displayalerts=false
'your code
application.displayalerts=true


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539387