WorksheetBase.Calculate Event

Occurs after the worksheet is recalculated.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public event DocEvents_CalculateEventHandler Calculate

The following code example demonstrates a handler for the Calculate event that displays the name of the worksheet when it is calculated.

This example is for a document-level customization.

private void WorksheetCalculate()
    this.Calculate += new 

void Worksheet1_Calculate()
    MessageBox.Show(this.Name + " is being calculated");

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft