Protect spreadsheet from being saved

O

Otto

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.
 
M

Mike

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
 
Top