View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Trapping Excel Close Event

As replied to the previous posting of this question:

There is no event fired for Excel itself closing. You can trap workbooks
closing with the BeforeClose Event. It sounds like you want this done at
the application level, so you would need to instantiate application level
events. See Chip Pearson's page on this

http://www.cpearson.com/excel/appevent.htm

--
Regards,
Tom Ogilvy


Bob J. wrote in message
...
Can anyone help with trapping the application.quit event
that is triggered by clicking on the close (X) box in the
upper right title bar or when the user performs a
File_Exit command and there is no Save Box genereated?
Workbook_close and _Deactivate do not seem to work.

Thanks

Bob