How to enable macros in Excel?

Microsoft Excel spreadsheets can contain scripts known as macros. Macros are small, simple programs within Excel or other Office programs that can automate common tasks.

There was a time when macros were very common in Excel, but macro viruses malicious macros that could inflict serious harm forced Microsoft to implement safety and security precautions, including disabling macros by default.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here’s how to enable macros.

How to enable macros in Excel

If you are willing to accept the risk of enabling all macros in Excel, you can permanently enable them using the Trust Center.

1. Click “File” and then click “Options.”

2. In the Excel Options window, click “Trust Center” in the navigation pane on the left.

3. Click “Trust Center Setting”

4. In the navigation pane on the left, click “Macro Settings.” 

5. In the Macro Settings section, click “Enable all macros (not recommended: potentially dangerous code can run)” and then click “OK.” As the option warns, this is a dangerous choice and not recommended.

Join Tip3X on Telegram