A family of Microsoft word processing software products for creating web, email, and print documents.
Dear @Marvin Bergeleen,
First of all, I sincerely apologize for the inconvenience you’ve experienced with blocked macros in Word
For better assist, please kindly let me know some information:
- Please provide your Word version by going to File > Account > About Word?
- Is the spreadsheet stored on your local drive, a network share, or a synced folder like OneDrive/SharePoint?
- Does this happen with all downloaded macro-enabled files or just this one spreadsheet?
- Are there any users in your organization who have experienced the same issue?
In the meantime, please help me review and check these steps to narrow down the problem:
1.Enable Trusted Locations in Word
- Go to File > Options.
- Select Trust Center, then click Trusted Locations from the left pane.
- Please verify and configure the following settings:
Check: Allow Trusted Locations on my network (not recommended)
Uncheck (ensure this option is not selected): Disable all Trusted Locations
2.File block Settings on Trust Center
- Trust Center Settings window > On right pane click > Protected View > Uncheck the "Enable Protected View for files originating from the Internet > Click OK. (test by disabling temporarily)
- Trust Center Settings window again > On right pane click > File Block Settings, try UNCHECKING all boxes.
- Save and Restart
- Test the file and macros
3.Resolve missing VBA references / 32-bit DLL Issues.
- Open the files. If you get a compile error, click Debug to open the VBA editor.
- In VBA > Tools > References. Look for any references marked missing: uncheck it or fix by installing the required library.
- If the file is a 32-bit Active X/COM DLL, like swedll32.dll or other legacy DLL, install the 64-bit equivalent or dun the 32-bit Office build (or update the code to avoid that DLL). If the DLL is essential and only 32-bit exists, you either need 32-bit Office or an updated component compiled for 64-bit.
4.Disable suspicious Add-ins.
- In Word > File > Options > Add-ins.
- On the bottom part >choose COM Add-ins > Go > Uncheck all non-Microsoft add-ins > OK
- Restart Word and test the file with Macro.
5.Repair and Update try to Repair Word.
- Settings > Apps > Installed Apps > Microsoft Office > Modify > Quick Repair (as first try) > Online Repair (if quick repair fails). For reference: Repair an Office application
6.Check organizational IT policies (If applicable to your organization):
Please kindly contact your IT Admin to check Policies for Microsoft 365 apps:
- Ensure your organization IT did not enable "Block macros from running in Office files from the internet" for Word in https://config.office.comMicrosoft 365 Apps Admin Center > Customization > Policy Management.
Find Your Microsoft 365 Admin: If you’re unsure who the Global Admin is within your organization, you can find guidance on locating them here: How do I find my Microsoft 365 admin?
I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.
Thank you for your patience and your understanding. If you have any questions, please feel free to reach out.
I'm looking forward for your reply.
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.