Share via

How to unblock macros/ enable macros in excel?

Anonymous
2024-02-23T07:24:56+00:00

I am unable to unblock Macros from Excel. I have enables Macros but still Macros and VBA Code is not running. Security risk message is shown by excel.

Microsoft 365 and Office | Excel | For home | 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
    2024-02-23T09:27:26+00:00

    Hello Rathi R! I'm Gunasekar and I'd be happy to help you with your question.

    I understand that you're facing issues with unblocking macros and running VBA code in Excel, despite enabling macros. Here are some steps you can try to troubleshoot the issue:

    A. Check Macro Security Settings:

    1. Open Microsoft word or Excel.
    2. Select the file and click Options
    3. Select Trust Center.
    4. Click Trust Center Settings and
    5. Select Trusted Locations.
    6. Select Add a new location.
    7. Add the domain.
    8. Make sure you check "Subfolders of this location are also trusted"
    9. Click OK to save.

    Restart the Office apps and run the Macros.

    B. Ensure the file is unblocked. To do that,

    1. Right-click on the Excel file and select Properties.
    2. In the General tab, check the "Unblock" box if it's available.

    https://learn-attachment.microsoft.com/api/attachments/5e07951e-55a7-4b1a-ac37-aa8f3bdc1803?platform=QnA

    Note: These methods are only effective when the Organization has not Blocked Macros via Group Policy. And in this case, I assume that your IT Admin configured Disabling Macros via Group Policy settings.

    Enable or disable macros in Microsoft 365 files (Related article for your reference)

    https://support.microsoft.com/help/12b036fd-d140-4e74-b45e-16fed1a7e5c6

    I hope this information helps. If you have any questions, please let me know and I will be happy to help you further.

    Best regards,

    Gunasekar N

    0 comments