Thread: DisplayAlerts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default DisplayAlerts

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?
--
Gary''s Student - gsnu200714