Block users from saving document

[CraigFord]

Hi

i have created a master document that i want anybody to be able to use, input data ect, however i dont want them to be able to save over the master

there are 2 macros in the docuemnt, one uses save as and the other uses export to pdf, these need to remain uneffected,

i gave tried to save the document as a template but it stops my macros working correctly.

what is the best way to do this?

 

[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

 

[CraigFord]

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

sorry, new to VB where do i find the ThisWorkbook Module

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor. In the Project window you should see ThisWorkbook. Double click it and paste in the code.