close window trapping

[Yury Lobanov]

I suppose this question sounded here many times.
But i don't know how to find in old news articles.

The question is:

How to catch window closing in excel 2000.
There is only "WindowDeactivate" Event.

Thanks, Yury

 

[pikus]

There's this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Su

 

[Yury Lobanov]

"Workbook_BeforeClose" doesn't fit
I have some windows of a workbook and want to catch window closing, not
workbook's