excel save event

Add-in Express™ Support Service
That's what is more important than anything else

excel save event
 
Andreas Dobler




Posts: 12
Joined: 2006-05-01
when the close event from a workbook is sent, an the user selects "yes, save the workbook", the save event is fired.
i set e.cancel = true, and activeDocument.Saved = true
--> excel fires the save event until e.cancel is set to true.

word handles that case correct ( its accepting the Saved = true)

do you now an workaround?
Posted 06 Jul, 2006 05:05:40 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hi Andreas.

Yes, you are right. Try to set the Saved property to true in the WorkbookBeforeClose event handler.
Posted 06 Jul, 2006 09:40:04 Top