I am looking for a way to disable the update prompt when the workbook is opened and disable the save prompt when the workbook is closed.

1. I know how to disable the update prompt under the tools menu, but that only disables on my pc, when other open the file from their pc it will still prompt them unless that have unchecked it also.

2. The file is set as read-only so if they do click save it prompts them to save as...etc.

I would prefer to eliminate these options to my end user so that they don't misclick etc. The file always needs to update so they don't need an option and they never need to save so therefore they don't need an option. Any suggestions are very appreciated.

Thanks,

Mike (Nashville)