
Hi @Geoff Wilkinson,
You can designate the folder on the NAS as a Trusted Location by going to File > Options > Trust Center > Trust Center Settings... > Trusted Locations and clicking "Add new location". In the "Microsoft Office Trusted Location" dialog box, enter the path to the folder on the NAS and select "Subfolders of this location are also trusted". Click "OK" to close the dialog box. Check "Allow Trusted Locations on my network (not recommended)" and click "OK" to save.
If the macros don't work still, go to Macro settings and select "Enable all macros(not recommended...)".
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.