To enable macros in Excel, you just need to access the Trust Center and change the configuration. This is very straightforward; just consider that when you enable macros, any file will be able to run code on your computer, which is potentially dangerous.
Steps
-
Go to the File menu in Excel.
-
Scroll down to Options menu.Advertisement
-
Select Trust Center in the window that pops up.
-
Click the "Trust Center Settings" button on the bottom right of the "Trust Center" tab.
-
On the Trust Center choose "Macro Settings" tab (left).
-
Enable all macros.
-
Click "OK", then "OK" again to apply.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- Keep in mind that enabling all macros might be dangerous if you don't handle with care which files you open.Thanks
Advertisement
About this article
Thanks to all authors for creating a page that has been read 83,220 times.
Advertisement
