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

G

Guest

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?
 
D

davesexcel

try
application.displayalerts=false
'your code
application.displayalerts=tru
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to stop the popup warning window when clicking on a hyperlink 1
How do I stop the Office popup window "Some files can contain viru 1
Can you hyperlink to a hyperlink? 1
Hyperlink to a movie popup message 3
Remove hyperlink, web link, and using Advanced filter 1
popup warning 1
How to create a hyperlink to open a file with part of the name 4
hyperlink - clicking on hyper link to select cell in another sheet 3

Top