Excel document Security Question

[cashchris2005]

Hello All,

I have a document that I am allowing all users on the shared drive to access... How can I make it so that the user can use my document template, but not save over it, but instead they have to save their changes/copy to a new location. This way when another user accesses the template it will be clear for them to input their information.

I hope this makes since.

Thank you.

 

[VoG]

Try this in the ThisWorkbook module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Not SaveAsUI Then
    Cancel = True
    MsgBox "You can only Save As", vbInformation, "NOT SAVED"
End If
End Sub