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.

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.

Yes, but you can subscribe to the event from somewhere other than the
workbook, and we can listen to the Application_WorkbookBeforeClose event
instead.

Thanks,
Aaron Queenan.

"Tom Ogilvy" wrote in message
...
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.

That doesn't change anything you have spoken of - it is still triggered
before close. Apparently you aren't asking a question, so continue to
proselytize the gathered masses.

Regards,
Tom Ogilvy


"Aaron Queenan" wrote in message
...
Yes, but you can subscribe to the event from somewhere other than the
workbook, and we can listen to the Application_WorkbookBeforeClose event
instead.

Thanks,
Aaron Queenan.

"Tom Ogilvy" wrote in message
...
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.

I am asking for a way of receiving an event either when the workbook is
REALLY ready to close, or after the workbook has closed.

Regards,
Aaron Queenan.

"Tom Ogilvy" wrote in message
...
That doesn't change anything you have spoken of - it is still triggered
before close. Apparently you aren't asking a question, so continue to
proselytize the gathered masses.

Regards,
Tom Ogilvy


"Aaron Queenan" wrote in
message
...
Yes, but you can subscribe to the event from somewhere other than the
workbook, and we can listen to the Application_WorkbookBeforeClose event
instead.

Thanks,
Aaron Queenan.

"Tom Ogilvy" wrote in message
...
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.