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.

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.

Thanks, Mike but this is way over my head. Where does this go?

"Mike" wrote:

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.