Just use Ontime to fire a macro after it is closed. Chip has lots of detail
at http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Spreadsheet Solutions" wrote in message
. ..
I know that this event does not excists, but I need one.
Does anyone know how to create or mimick such an event.

The reason is a bit complicated, but a hint in a good direction is
nonetheless very much appreciated.