Protect spreadsheet from being saved
use the before close workbook event
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = True Then Cancel = True
End Sub
this immediatly cancels save as as soon as it is selected provide macros are
enabled
"Otto" wrote:
Is it possible to protect a spreadsheet from being saved under a different
name or in a different folder? I have people that will save a training
schedule to their own directory and then not get the updates.
|