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.
Slashdot Mirror
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.