Macro to remove the option to save as if file was open as read only?
Running Excel 2003 with Windows 7
I have a workbook that I have set up with security to recommend open as read-only and if not there is a password that has to be entered so changes can be made to it. But when I open it as read-only and try to close out it give me an option to save-as. Is there a way to remove this option so when everyone is closing out it just closes it with out giving anyone any options to save or save-as when it is opened as read-only?