DisplayAlerts

  • Thread starter Gary''s Student
  • Start date
G

Gary''s Student

I am trying to follow a hyperlink without generating a warning and am using:

Sub openit()
Dim s As String
s = "file:///c:\b.xls"
Application.DisplayAlerts = False
ActiveWorkbook.FollowHyperlink Address:=s
Application.DisplayAlerts = True
End Sub

I am, however still getting a warning: "Hyperlinks can be harmful....."
How do i surpress this?
 

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

Save BeforeClose 1
Delete sheets code error requires object 2
Word macro that can call cells out of Excel for a find and replace 0
Screen alerts 6
save and exit macro 8
Microsoft Security Warning 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
XL03: Avoid "workbook contains links" msg when opening 6

Top