captcure close application event

[suru]

Hi,
I am new to VBA.

Can anyone tell me how to capture Close Application (i.e. close all
workbooks)
event in Microsoft Excel using VBA?


I know that, when i say close all, Microsoft Excel, fires close
workbook for each workbook.
But i need to know, if the user has clicked "close application",
since i need to do data clean up on that event.


thnx,
suraj

 

[Bernie Deitrick]

suraj,

There is no application level exit event. To see what events are available, visit Chip's page on
events:

http://www.cpearson.com/excel/Events.aspx

"Another method to determine what events are available is to create an empty class module, and enter
the following code:

Dim WithEvents App As Application

<snip>

Then, select App in the left side dropdown at the top of the code window. All the events for the
selected item in the left dropdown will be listed in the right dropdown."

HTH,
Bernie
MS Excel MVP

 

[suru]

thnx for the inputs