EXCEL close event?

[bmm]

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

 

[Tom Ogilvy]

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