Are you using the followhyperlink method? I haven't used that too much, mainly because (AFAIK) it was initially designed to emulate browser behaviour, thus it became susceptible to all the security baggage that eventually came with that. Perhaps someone here knows of a more simple solution, but I'm thinking you'll have to make use of folder/file navigation using either the msoFileDialogFolderPicker or msoFileDialogFilePicker to navigate to the files you want to open. I only say that because you've covered Trusted Locations as a reason. What you haven't said is if the file opens after you deal with the prompt. Maybe you could set the folder location to be a trusted web site...
https://support.office.com/en-us/art...8-143336039bbe
Last edited by Micron; 06-23-2017 at 05:02 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.