View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
suru suru is offline
external usenet poster
 
Posts: 2
Default captcure close application event

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