XLL+ Class Library

CXllApp::OnSheetCalculate

Called by the framework when any worksheet is recalculated

[C++]
virtual void OnSheetCalculate(
   LPDISPATCH dispWorksheet
);

Parameters

dispWorksheet

Pointer to dispatch interface of type Excel.Worksheet.

Remarks

This function is called whenever a worksheet is recalculated, at the end of the recalculation process.

Note that it will only be called if event-sinking is switched on (using CXllApp::SetSinkEvents()).

You can override the method in your application class to react to the event. The default method does nothing.

Note that the function is called once for each worksheet that is recalculated, at the end of the sheet's recalculation.

Implementation note

You should only implement this function if you need access to Excel's COM interfaces. If you just want to call an add-in function, use the much simpler mechanism provided by CXllApp::SetComEventHandler().

Requirements

Header: xllplus.h

See Also

CXllApp Class | CXllApp Methods | CXllApp::OnSheetDeactivate() | CXllApp::OnWorkbookActivate() | CXllApp::OnSheetSelectionChange()