Download Article
Download Article
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
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
Advertisement
About This Article
Thanks to all authors for creating a page that has been read 81,952 times.
Advertisement