DisplayAlerts

=?Utf-8?B?R2FyeScncyBTdHVkZW50?=

Guest

Posts: n/a

9th Apr 2007

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

« about the limitation of bas module | excel loading add-in.. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application.DisplayAlerts	Jac Tremblay	Microsoft Access VBA Modules	4	12th Mar 2008 03:49 PM
Where to put DisplayAlerts = False	Joe Fish	Microsoft Excel Programming	2	22nd Oct 2005 09:13 PM
DisplayAlerts (Which Ones?)	=?Utf-8?B?S2xhdHV1?=	Microsoft Excel Programming	2	30th Jun 2005 02:09 PM
DisplayAlerts	Howard Kaikow	Microsoft Excel Programming	12	29th Apr 2005 04:24 PM
Re: Can't Set DisplayAlerts to False	Mark Driscol	Microsoft Excel Programming	0	7th Apr 2004 06:11 PM