Have a need to run come VBA code when ProcessBook closes, but the object model doesn't include such an event for the Application object.
Is there a way to get this functionality?
The Application object has a DisplayDeactivate and ProcBookDeactivate event, but the help on the Display object's Deactivate event states that this event doesn't occur when a Display is closed.
The Display object has a BeforeClose event which might be of some use - by doing a Displays.Count to monitor when the last Display is closed - but the ProcBook object doesn't have a BeforeClose event. And besides, just because all open ProcBooks and Displays have been closed doesn't mean that the Application isn't still open.
What am I missing?
Jhcoxx
