Microsoft blocking my macro from running

Question

I have files with macro from a trusted site (my company) with macros attached, i have enabled macro from the trust center but still it is blocking it from running? please assist.

[Moderator note: personal info removed]

Answer 1

Dear @Benyam Mamo,

Good day! Welcome to Microsoft Q&A forum!

Based on your description, I understand that you're experiencing an issue where your Excel macro files are being disabled due to being marked as from an untrusted source, even though you've already enabled macro from the Trust Center, and you're looking for guidance on how to unlock or enable these macros.

I sincerely apologize for the inconvenience caused by this issue. 

To understand the situation better and provide you with the most suitable support, could you confirm the following information:   

• What version of Excel are you using? You can check it via File > Account > About Excel 
• Has this macro worked on your device before, or is this a first‑time issue? 
• Is this happening on one file or all macro‑enabled files? 
• Is the affected file stored locally on your computer, or opened from a network share, SharePoint, OneDrive, or email attachment? 
• Where is the file currently saved? (Local computer, Downloads folder, network drive, SharePoint sync folder?) 
• Does this file work for other colleagues, or is it blocked only on your device? 

Your confirmation would be very helpful in ensuring you receive the most suitable support! 

In the meantime, kindly try the following suggestions to check what might have caused the issue: 

• Check if the file is blocked by Windows: Sometimes, Windows marks files downloaded from external sources as blocked 
  • First, please close Excel and go to where the file is located on your computer 
  • Right‑click the Excel file > Select Properties 
  • 
  • Under the General tab, look for an Unblock checkbox, click 'Unblock' and 'OK' (this applies to files downloaded from external sources) 
  • Kindly recheck if the macros can run
  • 
• Add your file location as a trusted location 
  • Select File > Options 
  • Select Trust Center > Trust Center Settings > Trusted Locations 
  • Select Add new location 
  • Select Browse to find the folder, select a folder, and then select OK 
  • Click the checkbox "Subfolders of this location are also trusted"   
  • Click OK and Restart Excel
  • Then reopen the affected file and check if the issue persists
  • 
• Test with a new macro file to check the behavior 
  • You can create a simple new macro‑enabled Excel file 
  • Save it to the same trusted location 
  • Add a basic macro and reopen it to see if the macros are also disabled and let me know the result 
• Test the same file on another device: To help determine whether this issue is specific to your device or related to the file itself, I recommend testing the same Excel file on another computer. 
  • Copy the exact same macro‑enabled file to another device 
  • Open the file using the desktop version of Excel 
  • Kindly observe whether the macros are blocked or allowed to run 

For references:  

• A potentially dangerous macro has been blocked 
• Macros from the internet are blocked by default in Office

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. 

Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. 

Any updates you’re able to share would be really helpful. I appreciate your time and look forward to hearing how things are going!  

Thank you for your time and patience. 

---

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.