Stop workbooks from being saved

I have work books that are shared via a server with the folder set that anyone can view them as a read only. Is there any way that I can stop the work sheets ( may be with some VBA code) being saved under a different name to protect all the work I have put in to these.

Try pasting

Please Login or Register  to view this content.

into the ThisWorkbook tab in the VBA editor (Alt F11). This effectively disables the save operation.

In order to allow you to save the workbook containing this code, type

Please Login or Register  to view this content.

into the Immediate window (control G) to temporarily stop the application firing this code.

Thank you , I have tried the code but it will not allow me to save?
Is there a way I can put a code into a macro with short cut key to disable the code so I could either safe changes to the workbook with a button or save changes only made by me but with the save buttons disabled again on re-opening.

Of course they can open without enabling macros & save the workbook

Or they could just copy the workbook and rename it.

Dom

Oh, and don't forget to turn events back on again...

Originally Posted by mrice

Please Login or Register  to view this content.

into the Immediate window (control G) to temporarily stop the application firing this code.

Dom

You could make it so only you can save it using something like this:

Please Login or Register  to view this content.

Dom