Trapping Excel Close event
 

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?

Trapping Excel Close event
 

If want to control how a particular file closes, file BeforeClose event
You can add it to Workbook object:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
....
End Sub

Just go to VB editor, select the project, and click on ThisWorkbook. You
should see this event in the list of events.

It works in Excel 2000 and later, not sure about earlier versions.

RADO



"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?

Trapping Excel Close event
 

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?

Trapping Excel Close event
 

-----Original 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?
.
I believe that you are right. I am trying to treat this
as an application event and still can't seem to hook the
closing when there are no changes to the existing
workbook.

Bob