|re: "...thought it could be turned off for a particular file"|
It can be...sort off. I can't test any of these options at the moment, so I'm working from memory.
I believe that the "Disable all macros with notification" option will check each file and present a warning if the file contains a macro. I believe that the user is given the option to enable macros just for that file but it might be for just that session. At least the user wouldn't have to go into the Trust Center every time. See here:
See this site about storing files in a Trusted Location. When a Trusted Location is used, the macro security settings in Excel are essentially ignored, thereby enabling macros for any files stored there.
There is also a means to Digital Sign a workbook containing macros as a workaround for this issue, but I am not familiar with the process. You might want to Google around to see if that option might work. I believe that the user has to create the workbook that they want to sign, so I don't know if that even fits your situation.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.