View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default EXCEL close event?

There is no Excel close event. There is an application level event
equivalent to the Worbook_BeforeClose event, and it would be triggered as
each workbook closes, but I don't believe there would be any way you could
tell that the Excel application was being closed.

Chip Pearson has some reference pages on events and application level events
(2nd reference).

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

--
Regards,
Tom Ogilvy

"bmm" <newsgroup.com wrote in message
...
Hello ,

I want to know if we have separate events for Workbook close and Excel
close events.
I tried to handle the event Workbook_BeforeClose(), but how can we
differentiate if it was workbook close or excel close event.

Thanks and regds
BMM