The Excel object model provides a Before_close event which apparently triggers directly after the close command is given. After this macro has run the option to save the workbook is offered if the saved property is set to false.

I need to find a way of detecting the event AFTER the save dialog box has been processed or not shown at all. In other words, I want to detect when the workbook is actually about to close and do absolutely nothing else.

Any ideas? Is there a way of generating an 'on_close' event?

Thanks in advance

Martin