Events for workbook close

  • Thread starter Thread starter Aaron Queenan
  • Start date Start date
A

Aaron Queenan

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
 
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.
 
If I use that, I then have to write an "Are you sure?" dialogue for every
language of Excel we want to support. Isn't there a less ridiculous 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
 
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.
 
Hi Aaron,
What will happen if the "Are you sure?" dialogue is visible when the OnTime
event fires? Will it fail (and therefore never call the procedure) or sit
in a queue waiting patiently?
Click to expand...

The procedure call set by OnTime will be queued up and will fire as soon
as it has the chance.
Is there any way to tell when Excel has finished showing the dialogue, e.g.
the message loop that handles COM events starts working again?
Click to expand...

Not that I'm aware of, although I've never tried to subclass Excel at
this level. At any rate, I don't think it's necessary, because the procedure
set by OnTime will fire as soon as the alert dialog is dismissed, so that
will provide you with notification.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Back
Top