Generally, when you download a Macro-enabled Excel Workbook, upon opening the Workbook you’re given the option to ‘Enable’ the macro.
If you’re not provided that option, there are a few reasons why as well as a few solutions. The reasons are that either your administrator, a setting in your Excel install, or your anti-virus software is blocking you from being able to enable the macro.
Here are a few solutions for this issue:
Microsoft has blocked macros from running because the source of this file is untrusted. What do I do?
In newer versions of Excel, users must follow more involved steps to enable Macros. This security feature from Microsoft is meant to protect Excel users from bad actors, but as a consequence makes enabling macros from A.CRE users a bit more difficult! Click here to learn how to enable Macros when you get the warning “Microsoft has blocked macros from running because the source of this file is untrusted.”
(Click here to read more about how Microsoft Excel blocks Macros and how to enable them)