calculate(f9) event at workbook level?
"avi" wrote:
Is the such an event at the workbook level and not
only at a sheet level?
I want the event fired independently of the active sheet
There is the Workbook_SheetCalculate event macro.
It is called after __each__ worksheet is recalculated -- and after that
worksheet's Worksheet_Calculate event macro is called, if any.
So it is called multiple times when we press ctrl+alt+F9, for example.
That might not meet your needs if you want an event that is called only once
after __all__ worksheets are recalculated.
|