How to capture the event before any sheet calculating in Excel

[JohnDing]

I only know how to capture the calculating event
in "Sheet_Calculation" event, but it's only available in
a certain workbook, if worksheets in other workbooks
calculates, it does not work, so would there be a way to
capture this event at Application level?

Thanks

 

[Dave Peterson]

Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample workbook. Don't
miss that.