View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tournifreak Tournifreak is offline
external usenet poster
 
Posts: 6
Default 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.