Let’s see how we can Enable or Disable macros in an excel workbook.
Click on File at the top left corner in the excel workbook and click on Options at the last.
Click on Trust Centre Settings under Trust Centre Options at the bottom right.
You will see the below macro settings window where you could select the options as per your requirement to enable or disable the macros, press ok and save and close the file.
Your change in settings will be reflected now.
Hope this helped.