Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to capture the event before any sheet calculating in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to capture the event before any sheet calculating in Excel
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. JohnDing wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture the hyperlink event before it goes to the link | Excel Discussion (Misc queries) | |||
Capture event when exit Column G | Excel Discussion (Misc queries) | |||
How to capture the event before any sheet calculating in Excel | Excel Programming | |||
Capture scrolling event | Excel Programming | |||
VBA capture File SaveAs Event | Excel Programming |