A macro is a series of commands that you can use to automate a repeated task, and can be run when you have to perform the task. Here is a step-by-step instructions on how to enable Macros in Excel.
- Go to the File Menu in Excel
- Scroll down to Options Menu.
- Select Trust Center in the window that pop up.
- Click the “Trust Center Settings” button on the bottom of the “Trust Center” tab.
- On the Trust Center choose “Macro Setting” tab.
- Enable all Macros.
- Click OK, then OK again to apply.
Understand Macros Settings
Disable all macros without notification: Macros and security alerts about macros are disabled.
Disable all macros with notification: Macros are disabled, but security alerts appear if there are macros present. Enable macros on a case-by-case basis.
Disable all macros except digitally signed macros: Macros are disabled, but security alerts appear if there are macros present. However, if the macro is digitally signed by a trusted publisher, the macro runs if you have trusted the publisher. If you have not trusted the publisher, you are notified to enable the signed macro and trust the publisher.
Enable all macros (not recommended, potentially dangerous code can run): All macros run. This setting makes your computer vulnerable to potentially malicious code.
Trust access to the VBA project object model: Disallow or allow programmatic access to the Visual Basic for Applications (VBA) object model from an automation client. This security option is for code written to automate an Office program and manipulate the VBA environment and object model. It is a per-user and per-application setting, and denies access by default, hindering unauthorized programs from building harmful self-replicating code. For automation clients to access the VBA object model, the user running the code must grant access. To turn on access, select the check box.
Source: 1) Wikihow