Running either of the code examples here will generate an error:
Screenshot 2025-02-10 195119.png


unless you have given permission for VBA to access the code project

To grant permission:

1. File | Options | Trust Center | Trust Center Settings
   
   Screenshot 2025-02-10 195903.png
2. Check the option to Trust access to the VBA project object model
   Screenshot 2025-02-10 195740.png

NB: This is not generally considered a safe thing to do unless you really know what you are doing as it will also allow malware access.

Absolutely! And, given that you'd really want to be granting access before running the macro then removing it immediately afterwards each time you want to do a backup, I fail to see what's gained over simply pressing Alt-F11 to open the VBE, then manually exporting the code & forms requiring backup.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Or, even better, prevent the issue from occurring in the first place by storing code in a template located in the user startup folder, instead of Normal.dotm.