Apr 17 2022 05:59 AM - edited Apr 17 2022 06:44 AM
Apr 17 2022 06:44 AM
Select File > Options > Trust Center > Trust Center Settings... > Macro Settings.
Select "Disable macros with notification", then click OK.
When you open a macro-enabled workbook, you should get a prompt to allow macros; click Yes.
You can set one or more folders as Trusted Locations in File > Options > Trust Center > Trust Center Settings... >Trusted Locations. If you save a workbook in a trusted location, macros will automatically be enabled.