Do not let user save template if it has been been modified
Hi all,
I have a template that I do not want it to be saved under any
circumstances when any part of it is modified. I have been able to
program the X button not to save with:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Saved = True
End Sub
but not sure what coding is needed so it will not save if the user click
the save button or chooses the file|save or file|save as option from the
menu item.
Thanks in advance.
|