enable macros in excel

Hello @a83395,

Thank you for reaching out to the Microsoft Q&A forum.

I understand that you are currently experiencing an issue with macros in your Excel file.

When macros are disabled, you will see a security warning upon reopening the document and attempting to run a macro, as shown in the screenshot below:

Please select “Enable Content” and confirm by clicking “Yes” to make this file a Trusted Document.

Once enabled, the macro should work normally.

Additionally, you can manage macro settings through the Trust Center:

• Go to File > Options > Trust Center > Trust Center Settings…
• Under Macro Settings, choose the appropriate option.

For more details, please refer to: Enable or disable macros in Microsoft 365 files - Microsoft Support

If you encounter an error while executing the macro and it was previously enabled, please provide additional details such as:

• File type
• Office app version
• Operating system
• Screenshots of the issue
• Duplicate file and open it to see if Security Warning is showing

This will help us better understand the problem and provide an accurate solution.

Looking forward to your response.

To enable macros in Excel, you can follow these steps:

1. Open Excel and go to the File menu.
2. Click on Options at the bottom of the left sidebar.
3. In the Excel Options dialog, select Trust Center from the left menu.
4. Click on the Trust Center Settings... button.
5. In the Trust Center dialog, select Macro Settings.
6. Choose the option that suits your needs:
   • Disable all macros without notification (not recommended)
   • Disable all macros with notification (recommended, allows you to enable macros on a case-by-case basis)
   • Disable all macros except digitally signed macros (only allows macros from trusted publishers)
   • Enable all macros (not recommended, as it can expose your system to potentially harmful macros)
7. Click OK to save your settings and exit the dialogs.

After enabling macros, you may need to reopen your Excel file for the changes to take effect. If the file is from the internet, ensure that it is saved in a trusted location or remove the Mark of the Web from the file to allow macros to run.

References:

• Steps to take to allow VBA macros to run in files that you trust
• Use policies to manage how Office handles macros