Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture close excel event in .xla
Hi - I hope someone can help.
I'm trying to capture the event where someone closes Excel (using the red "X"). My code is in an .xla and no other workbooks are open except the hidden .xla. My code is in "This Workbook" of the hidden .xla I've tried: Workbook_BeforeClose(Cancel As Boolean) Workbook_WindowDeactivate(ByVal Wn As Window) Workbook_Deactivate() Workbook_SheetDeactivate(ByVal Sh As Object) None are captured - Excel just shuts down without triggering. The funny thing is, Workbook_Open() does trigger when the xla is opened. I'm using Excel 2000 if it makes any difference. Does anyone have any ideas? Thanks & regards, Jon. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture Excel close | Excel Programming | |||
Before Close Event Hide all Worksheets then Close Application | Excel Programming | |||
How to Capture insert row event in Excel using VBA | Excel Programming | |||
How to capture the event before any sheet calculating in Excel | Excel Programming | |||
How to capture the event before any sheet calculating in Excel | Excel Programming |