What I have done for workbooks that multiple users use and which I do not want to have read-only copies open is to write code in a workbook_open sub which checks if the workbook is read only and if so closes the file. You may not want the file closed, but you should be able to do a similar check in the code that saves and closes after 10 minutes. For example it only saves and closes a workbook that is not read only.