Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open/Close Event and Excel Saving process | Excel Programming | |||
Resetting Excel commandbars on close event | Excel Programming | |||
Trapping Excel Close Event | Excel Programming | |||
Trapping Excel Close event | Excel Programming | |||
Excel main window close event | Excel Programming |