Disable saving in BeforeClose event

  • Thread starter Thread starter Franck
  • Start date Start date
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.
 
Try setting the Saved property of the book to True

THisWorkbok.Saved = True

--

HTH

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