Only allow worksheet to change if filename is not (for example) Template.xlsm

I have a template that everyone at work uses for filling out purchase orders. It has a built in contact list that is opened through a userform and is constantly being updated. The contact list is on say sheet4. Every once in a while users will accidentally fill out information and save over the master file. Is there a way to only allow changes to be made and saved on one worksheet but not save any of the changes on the other?

I think if there is a way to check what the filename is and if it is (for example) template.xlsm then do not allow certain macros or cells to be executed/changed but if they fill out some info and change the filename to (for example) template-0045.xlsm then allow changes.
This would act just like it is read only but a little different I guess.

Any help would be appreciated on this one!

hi,

Use the workbook event procedure.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If ThisWorkbook.Name = "text to raw.xlsm" Then
MsgBox "Please change the filename"
Cancel = True
End If

End Sub

regards,
lokicl