Protect spreadsheet from being saved
 

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.

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.

Protect spreadsheet from being saved
 

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.