"Dean" wrote...
....
I assume that then becomes a global EXCEL setting, but can I have this file
uncheck it when he opens the file and recheck it when he exits (or when he
resaves it)?
....

Record the method calls involved while performing these operations manually,
then add the unchecking code to the workbook's Open and Activate event
handlers and the checking code to the workbook's BeforeClose and Deactivate
event handlers.