How To Fix Error The Macros In This Project Are Disabled

When I create and run a VBA script in excel, I meet an error with the error message The macros in this project are disabled. This article will tell you how to fix it.

1. How To Fix Error The Macros In This Project Are Disabled.

  1. Open Excel, click the File —> Options item to open the Excel Options dialog.
  2. Click the Trust Center option item on the Exception Options dialog left side.
  3. Click the Trust Center Settings… button o.n the dialog right panel
  4. Then it will popup the Trust Center dialog.
  5. Click the Macro Settings item in the Trust Center dialog left panel.
  6. Then on the right panel Macro Settings section, check the radio checkbox Enable all macros (not recommended; potentially dangerous code can run).
  7. You should also check the checkbox Trust access to the VBA project object model on the right panel Developer Macro Settings section.
  8. Click the OK button to save the changes, close the Excel workbook file and reopen it.
  9. Now you can run the VBA script or Macro again, and the error will disappear.
  10. But be careful, before you do this, you had better backup your excel workbook file.
  11. And after executing the macro or VBA script, uncheck the checkbox.

2. References.

  1. How To Enable Developer Tab And Write VBA Source Code In Excel.

Subscribe to learn more excel tricks.

We don’t spam!

Subscribe to learn more excel tricks.

We don’t spam!

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.