Code doesn't run in a closed workbook, so there is no afterclose event.

Regards,
Tom Ogilvy


"Aaron Queenan" wrote in message
...
Are there any events when we KNOW the workbook is being closed?

The BeforeClose event is a nuisance, because the user can click cancel
afterwards. Rewriting the "Are you sure?" dialogue is a possibility, but
it's really a waste if there is a better way.

Thanks,
Aaron Queenan.