In Office 2016 for Mac, there are three levels of macro security available, as seen in the following screen shot:

If you're an admin, you might want to configure macro security for your users, in either of the following ways:
-
Set a default setting, which users can change.
-
Force a particular setting, which users can't change.
In either case, you can configure this setting by using a preference. The following is the information that you need to set the preference:
Domain |
com.microsoft.office |
Key |
VisualBasicMacroExecutionState |
Possible values |
DisabledWithWarnings (default) DisabledWithoutWarnings EnabledWithoutWarnings (not recommended) |
Here is some additional information about using this preference:
-
It's available starting with version 15.33 of Office 2016 for Mac.
-
It applies to Word, Excel, and PowerPoint.
-
It's CFPreferences-compatible, which means that it can be set by using enterprise management software for Mac, such as Jamf Pro.