Opening doc via hyperlink without warning

[CedarTree]

I have a table of documents (could be Word, Excel, OneNote, etc.) and when someone doubleclicks, I use Application.FollowHyperlink to open the doc. It works fine but the user also gets "warned" about opening up a file (sometimes it doesn't show up but it's annoying when it does). Any ways to suppress this? I tried setwarnings false but that didn't help.

 

[Mark_]

Looks like your link is to an untrusted location.

 

[CedarTree]

It's actually on the company intranet.

 

[isladogs]

It may be on your intranet but the location needs to be set as trusted with Access. That can also be true on your own computer for imported files.

 

[CedarTree]

Is there a way to do that within the Front-end so as I share the FE with users, they don't have to do anything?

 

[isladogs]

File...Options...Trust centre.