Hi Tony,

Make sure there are no Group Policies restricting macros. Also, note that template files .xltx, .xltm are not considered trusted documents.

Another thing you may try is to list the Recent Files file path from your computer, with this code:

This will print in Immediate window the full path of the recent files.

My guess is that you have files with "https://d.docs.live.net/...." path in the list, and that cannot be a trusted location.

Hi Catalin,

Thanks for your reply. I don't have any group policies restricting macros. I have run the code you gave me and the list looks like this:

https://rutherfordsystems-my.sharepoint.com/personal/tony_rutherfordsystems_onmicrosoft_com/Documents/OneDriveWork/Clients/CtiC/CTiC%20Contacts%20Register.xlsm
https://rutherfordsystems-my.sharepoint.com/personal/tony_rutherfordsystems_onmicrosoft_com/Documents/OneDriveWork/Clients/CtiC/CTiC%20Contacts%20Register%20test.xlsm
UsersTonyOneDrive - Rutherford SystemsOneDriveWorkClientsCtiCData Export 2016-12-07-14-13-17.csv
UsersTonyOneDrive - Rutherford SystemsOneDriveWorkClientsCtiCData Export 2016-12-07-14-00-03.csv
https://rutherfordsystems-my.sharepoint.com/personal/tony_rutherfordsystems_onmicrosoft_com/Documents/OneDriveWork/RSA/Worklog/WorkLog.xlsm
UsersTonyOneDrive - Rutherford SystemsOneDriveWorkClientsCtiCCTiC Contacts Register.xlsm

The thing that puzzles me is that there are some circumstances where macros are enabled and other where they are not. I have tried opening the same macro-enabled workbook using four methods, and the results are:

1. Select from pinned files list: macros not enabled
2. Select from recent files list: macros not enabled
3. Select with File, Open, Browse: macros enabled
4. Double click in File Explorer: macros enabled

I can manage using the last two options, but it's a pain not being able to use the pinned/recent files list.

Thanks,

Tony

Hi Tony,

I think there is something else you can try:

You already have a tool for creating Self Signed certificates. (search your computer for "Manage file encryption certificates"). Use the wizard to create a self signed certificate stored on your computer, and use this certificate to digitally sign all your vba projects, in all files.

Next step is to change your macro settings, to Allow Digitally signed macros only.

Now, the recent files links should open with macros activated, if they are digitally signed.

I think you have to add that certificate in Trusted Publishers, Trusted Locations, and other locations if necessary.

Hi Catalin,

I have found the answer to my problem. I had never used OneDrive until three months ago, when I posted my query, and didn't fully understand how it worked.

When I open an Excel workbook by double clicking it in File Explorer or using File, Open, Browse..., I am opening a local copy of the file. I had defined the local path as a trusted location, so my macros were automatically enabled. When I open it using File, Open, OneDrive... or select it from the pinned or recent files list, Excel opens the copy on my SharePoint site. I had not defined this as a trusted location, so I got the prompt to enable macros every time.

I have now added my SharePoint site to trusted locations, and everything works.

Thank you for your help with this.

Tony

Great, glad to hear you managed to make it work, and thank you for your feedback, it's good to know which was the real source of the problem.