View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default 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.