Microsoft blocked macros

Marie Marteja 0 Reputation points
2025-09-12T06:16:44.19+00:00

how I will enable all macros in microsoft access, excel and word files

Microsoft 365 and Office | Access | For business | Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Dora-T 8,520 Reputation points Microsoft External Staff Moderator
    2025-09-12T07:24:18.5733333+00:00

    Hi @Marie Marteja

    Thank you for posting your question to the Microsoft Q&A forum. 

    I understand it can feel a bit confusing when macros are blocked, especially if you’re trying to get your work done quickly.  You can follow these steps to enable all macro: 

    1.For Word/Excel 

    -Go to File > Option > Trust Center > Trust Center Settings 

    -Choose 

    • Enable all macros (not recommended; potentially dangerous code can run).  
    • Optionally, check Trust access to the VBA project object model 

    -Click OK to apply 

    User's image

    User's image

    User's image

    User's image

    2.For Access 

    Go to File > Option > Trust Center > Trust Center Settings > Enable all macros (not recommended; potentially dangerous code can run) > Click OK to apply. 

    User's image

    User's image

    User's image

    User's image

    If the steps above don’t work for you, please let me know and also share which version of Word, Excel, or Access you’re using. That will help me provide more tailored guidance for your situation.

    I hope this helps.


    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.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.