Enable Auditing Or Use Group Policy to enable macr (Score 1)

You can enable auditing on the file server (go to the security tab of a parent folder and then click Advanced | Auditing). With this approach, you can audit all aspects of the files in the folder (if people are opening, deleting, changing, etc a file). Or, you can enable Group Policy and enforce the users to accept the macro settings you specify. With this approach, you can use the macro approach you outlined.