EXCEL close event?
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 |
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 |
All times are GMT +1. The time now is 05:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com