Macro Enabled Files Not Working

Issue/Question

Macro enabled files are not working on my computer

SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted.

Environment

• Microsoft Word
• Microsoft Excel
• Microsoft Office 365

Resolution

Note: Microsoft Office 365 automatically blocks Macros from the internet or other network storage. Macro enabled files on the Network Share (X Drive) must be copied to your computer before they will run, or the Network Share drive must be set as a trusted location in the Trust Center. More information regarding this change can be found here and here
Note: Microsoft has provided steps to take to allow VBA macros to run in files that you trust

• Macro enabled files are not supported by USD ITS
• ITS does not prevent their use, but we do not support them
  Note: If Windows Defender is blocking the use of your Macro file, follow Software Being Blocked by Windows Defender
• Please contact the supplier of the file for assistance

Setting the Network Share (X Drive) as a Trusted Location in Trust Center

1. Open Excel
2. Click Options
3. Click Trust Center
4. Click Trust Center Settings
5. Click Trusted Locations
6. Check Allow Trusted Locations on my network (not recommended)
7. Click Add new location...
8. Click Browse...
9. Click This PC
10. Select your network share (X Drive)
11. Click OK
12. Check Subfolders of this location are also trusted
13. Click OK
14. Click OK
15. Click OK
16. Open the file again