Surpressing a Message
 

I have several hyperlinks which I'm activating using VBA. Is there any
way to surpress the following message (Application.diDisplayAlerts =
False doesn't seem to work):


========================
MICROSOFT OFFICE

Opening blablah.sql

Some files can contain viruses or otherwise be harmful to your
computer
It is important to be certain that this file is from a trustworthy
source.

Would you like to open this file?

OK Cancel
========================

Any help much appreciated
Jason.

Surpressing a Message
 

I'm only asking this because of the way you spelled the command.
Did you spell the command right?
Application.DisplayAlerts = False
--
I am running on Excel 2003, unless otherwise stated. Please rate posts so we
know when we have answered your questions. Thanks.


"WhytheQ" wrote:

I have several hyperlinks which I'm activating using VBA. Is there any
way to surpress the following message (Application.diDisplayAlerts =
False doesn't seem to work):


========================
MICROSOFT OFFICE

Opening blablah.sql

Some files can contain viruses or otherwise be harmful to your
computer
It is important to be certain that this file is from a trustworthy
source.

Would you like to open this file?

OK Cancel
========================

Any help much appreciated
Jason.

Surpressing a Message
 

Generally speaking warnings about viruses and security issues can not be over
ridden. If you could then there would be no point to them as visues and such
would just turn them off...
--
HTH...

Jim Thomlinson


"WhytheQ" wrote:

I have several hyperlinks which I'm activating using VBA. Is there any
way to surpress the following message (Application.diDisplayAlerts =
False doesn't seem to work):


========================
MICROSOFT OFFICE

Opening blablah.sql

Some files can contain viruses or otherwise be harmful to your
computer
It is important to be certain that this file is from a trustworthy
source.

Would you like to open this file?

OK Cancel
========================

Any help much appreciated
Jason.

Surpressing a Message
 

Thanks Jim - had a feeling that might be the answer.

J

On 22 Sep, 18:52, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Generally speaking warnings about viruses and security issues can not be over
ridden. If you could then there would be no point to them as visues and such
would just turn them off...
--
HTH...

Jim Thomlinson



"WhytheQ" wrote:
I have several hyperlinks which I'm activating using VBA. Is there any
way to surpress the following message (Application.diDisplayAlerts =
False doesn't seem to work):

========================
MICROSOFT OFFICE

Opening blablah.sql

Some files can contain viruses or otherwise be harmful to your
computer
It is important to be certain that this file is from a trustworthy
source.

Would you like to open this file?

OK Cancel
========================

Any help much appreciated
Jason.- Hide quoted text -

- Show quoted text -