How to enable Macros in Excel | Beginners Guide
In this short video, learn how to enable macros in ms excel or ms word fast.
Definition: A macro is an action or a set of actions that you can run as many times as you want. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks.
Macro settings are located in the Trust Center.
--Click the File tab.
--Click Options.
--Click Trust Center, and then click Trust Center Settings.
--In the Trust Center, click Macro Settings.
--Select the option "Enable all macros (not recommended)"
--Click Ok button
Warning: Never enable macros in an Office file unless you're sure what those macros do. Unexpected macros can pose a significant security risk. You don't have to enable macros to see or edit the file; only if you want the functionality provided by the macro.
The steps are similar in Excel 2010, excel 2013, excel 2016, excel 2019