Canceling a quit event

[ETID]

Is there a way to cancel this event?

If a user clicks the X or Chooses File>Close, I would like to check for certain conditions, and if all are true, then close the app. if not then cancel the close event.

 

[segmentationfault]

Use the Workbook_BeforeClose( Cancel As Boolean ) event. Perform your tests and set Cancel=True if you want to disallow the close.

 

[ETID]

Thanks, that would be lovely, but I forgot to mention that I need to do this in Outlook, but I don't see a before close event or sub.



....any other thoughts?