Hi @James Gledson
Will this issue occur if you copy the .xlsm files out of the previous folder, such as to Desktop folder.
Are these .xlsm files stored on SharePoint server, and synced to local device via OneDrive?
If not, just a network file server, I suggest you following the link: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-centrally-located-on-a-network-share-or-trusted-website
• Designate the location as a Trusted site
• Add the location to the Local intranet zone
Besides, please set the Network locations as a Trusted Location in Office apps. For more information, see Trusted Locations for Office files.
If yes, please refer to the link: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-on-onedrive-or-sharepoint
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.