View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maddoktor Maddoktor is offline
external usenet poster
 
Posts: 31
Default 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.