How To Enable Macros In Excel?

By / Macro / Leave a Comment

macros


Enabling macros in Excel allows you to automate tasks and perform various operations. However, it's important to note that macros can pose security risks, so you should only enable them in trusted documents. Here's how you can enable macros in Excel:

Excel 2013, Excel 2016, Excel 2019, Excel for Microsoft 365:

  1. Open Excel: Launch Microsoft Excel and open the workbook in which you want to enable macros.

  2. Go to the "File" tab: Click on the "File" tab in the ribbon to go to the backstage view.

  3. Select "Options": In the backstage view, select "Options" at the bottom of the left-hand menu. This opens the Excel Options dialog box.

  4. Go to the "Trust Center": In the Excel Options dialog box, click on "Trust Center" in the left-hand menu.

  5. Click on "Trust Center Settings": In the Trust Center, click on the "Trust Center Settings" button.

  6. Enable Macros: In the Trust Center Settings dialog box, select "Macro Settings" on the left.

  7. Choose the appropriate setting: Under Macro Settings, you will see different options. Choose the setting that suits your needs. To enable all macros, select "Enable all macros" (not recommended for security reasons). Alternatively, you can choose "Disable all macros with notification" to receive a prompt each time a macro is present.

  8. Click "OK": After selecting your preferred macro settings, click "OK" to apply the changes and close the Trust Center.

  9. Click "OK" again: Back in the Excel Options dialog box, click "OK" to close the dialog box.

  10. Save and Close: Save your workbook if you haven't already, and close and reopen it for the changes to take effect.

Remember, enabling macros exposes your computer to potential security risks. Only enable macros in documents from trusted sources.

Excel 2010:

The steps are similar to the ones mentioned above, but the exact names and locations of options might vary slightly.

  1. Open Excel and go to the "File" tab.
  2. Select "Options" to open the Excel Options dialog box.
  3. In the Excel Options dialog box, click on "Trust Center" in the left-hand menu.
  4. Click on "Trust Center Settings" to open the Trust Center.
  5. Under Macro Settings, choose your preferred setting.
  6. Click "OK" to apply the changes and close the Trust Center.
  7. Click "OK" in the Excel Options dialog box.
  8. Save, close, and reopen your workbook.

Always exercise caution when enabling macros, especially in documents from unknown or untrusted sources. 

Put Comment for quarry