Disable saving in BeforeClose event

F

Franck

Hi,
Got my template XLT and I don't want my user to save any Spreadsheet
based on it.

In the BeforeSave event : no problem. Save is disabled.
But in the BeforeClose event, I can't figure out how to do as if I set
Cancel to True, the spreadsheet does not save (Yeah !) but does not
close anymore !!!

Thks for help.
 
B

Bob Phillips

Try setting the Saved property of the book to True

THisWorkbok.Saved = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top