Detecting closure of a workbook

[mrice]

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

[mikerickson]

Create an application level WorkBook_Deactivate routine that tests if the workbook is still there, if it isn't, it has just closed.
Something like this untested routine in a class module, perhaps.

Please Login or Register  to view this content.

[mrice]

Interesting approach - thanks. I'll give it a try.

[mikerickson]

The more I think about it, I prefer

(pseudo-code)

in a normal module

Please Login or Register  to view this content.

in a class module

Please Login or Register  to view this content.

If this code

Please Login or Register  to view this content.

is in the AppEvents code module, you will trigger for every workbook, or you could put the BeforeClose in ThisWorkbook code module for only those workbooks you wanted to trigger the alarm.

[mrice]

Many thanks for your thoughts on this one.