Temporarily disable macros

Question

I have a very buggy macro that keeps crashing Excel. I don't want to deal with it at the moment, but I do want to continue viewing and editing my workbook. How do I temporarily disable the macro?

Answer 1

Hello @HMM

Welcome to Q&A forum!

I will guide you step by step to complete this in the Excel application on your side, and I’ll include images so you can confirm everything is done correctly.

Guidance:

"File" -> "Options" -> "Trust Center"-> "Trust Center Settings"-> "Macro Settings" -> "Disable VBA macro with notification" -> "OK"

Enable or disable macros in Microsoft 365 files - Microsoft Support  

I hope my guidance can support you in this case.

Since this is a public forum and others may face the same issue with you. Therefore, if my information is helpful for you, please click “Accepted Answer” so it gets pinned and highlighted at the top, making it easier for others to find.

Together, we can make this forum a valuable resource for all users.

---

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.

Answer 2

To temporarily disable macros in Excel, you can adjust the settings in the Trust Center. Here’s how you can do it:

1. Open Excel and go to File.
2. Click on Options.
3. In the Excel Options dialog, select Trust Center from the left pane.
4. Click on the Trust Center Settings button.
5. In the Trust Center dialog, select Macro Settings.
6. Choose the option Disable all macros without notification. This will prevent any macros from running while you work on your workbook.
7. Click OK to apply the changes and close the dialogs.

This will allow you to continue viewing and editing your workbook without the macro causing crashes.

---

References:

• This document was opened with macros disabled
• Macros from the internet are blocked by default in Office