How To Enable Macros In Excel 2013-2016

Here is what to do, if the above error message is shown while opening a macro-enabled file:
(XLS, XSLM, XLSB) 
​

1. Click the File Tab (top-left most tab in the window)
   
   
2. Click the Excel Options butto.
   
   
3. Click Trust Center in the menu on the left
   
   
4. Click Trust Center Settings in the window on the right
   
   
5. In the new window that opens click Macro Settings in the menu on the left
   
   
6. Select Enable all macros
   
   
7. Click OK
   
   
8. Click OK
   
   
9. Close all Office applications and restart Excel

---

How to Enable Macros in Excel 2013-2016

---

How To Enable Macros In Excel 2010

​How to Enable Macros in Excel 2010

---

How to Enable Macros in Excel 2010

---

How To Enable Macros In Excel 2007

Click the Office Button (top-left most button in the window) and follow the same process. 

Please read this Microsoft support article: Enable or disable macros in Office documents

---

Frequently Asked Questions

Can I enable macros using VBA code?

For security purposes, there is no way to enable macros programmatically.

---

comments powered by Disqus