Trapping Excel Close event

  • Thread starter Thread starter Bob J
  • Start date Start date
B

Bob J

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?
 
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
 
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
 
-----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
Click to expand...
as an application event and still can't seem to hook the
closing when there are no changes to the existing
workbook.

Bob
 
Back
Top