How to enable macros in excel earliar than 2003 version

Open any excel workbook file.

  • In menu bar click Tools -> Macro – > Security. (See screenshot below)

Enable Macros in Excel

  • After that, you will see the window showing below. Click “Low” and hit “Ok”

Enable Macros

  • Close Excel and then reopen. Macros are now enabled in your workbook!

How to enable macros in excel Later than 2003 version

Open any excel workbook file.

  • In Ribbon, Click on File – > Option

  • Click on the last option “Trust Center” and then click on “Trust Center Settings…” it will open another popup as shownig in the screenshot below.

  • Click on “Enable all macros”, Hit Ok and close the file.
  • Restart the excel. Excel macros are enabled now!