Can not open a .xlsm from folder on c: drive.

[xluserg]

Hi all

I have an excel file open and in this file I have cells with a links to some .xlsm files that I would like to open. but recently I get a message saying...

Microsoft Office

Opening C:\ test\001,xlsm

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?

Been trying the last couple of days to correct this with no joy.

Any help appreciated.

Office 365 Excel 2016 64bit

Windows 10 64bit



Graham

 

[Fluff]

You can add that folder to the "trusted location" in File > Options > Trust Center

 

[xluserg]

Hi

I have aready added the folder to the Trusted locations and still does not open files. I did forget to say I am opening by vba code which I get the message and also get the message when clicking on the linked cell.

Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

Thanks for the help

Graham

 

[Fluff]

I cannot replicate that behaviour, so not sure what to suggest.

 

[xluserg]

No problem.

Thanks Fluff

Graham

 

[Fluff]

Sorry I couldn't have been more help.