Disable saving in BeforeClose event

[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.

 

[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)

 

[Franck]

GREAT ! Thks