Share via

unable to enable macros in excel

Anonymous
2025-06-10T12:19:37+00:00

Even after going to options , trust center settings and macros

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-06-10T12:41:26+00:00

    Dear James Waithaka, 

    Welcome to the community!   

    Here are some suggestions to enable macros in an Excel spreadsheet: 

    1. Open Excel and Access Settings:  
      • Open your Excel file.
      • Go to File > Options (or Excel Options on Mac).
    2. Navigate to Trust Center:  
      • In the Excel Options window, select Trust Center from the left menu.
      • Click Trust Center Settings.
    3. Enable Macros:  
      • In the Trust Center, select Macro Settings.
      • Choose one of the following options:  
        1. Enable all macros (not recommended due to security risks).
        2. Disable all macros with notification (recommended; prompts you to enable macros when opening a file).
      • Click OK to save changes.
    4. Enable Macros for a Specific File:  
      • If a macro-enabled workbook (e.g., .xlsm) is opened and macros are disabled, a Security Warning bar appears.
      • Click Enable Content to allow macros for that session.
    5. Save the File:  
      • Ensure the file is saved in a macro-enabled format like .xlsm (not .xlsx, which doesn’t support macros).
    6. You can find more information at the following link: Enable or disable macros in Microsoft 365 files - Microsoft Support

    If you want any further information or support, please let me know!      

    Best Regards,       
    Schneider-P MSFT | Microsoft Community Support Specialist

    1 person found this answer helpful.
    0 comments