This documentation is archived and is not being maintained.

Workbook.SheetCalculate Event

Office 2007
Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.


expression.SheetCalculate(Sh, )

expression   An expression that returns a Workbook object.


NameRequired/OptionalData TypeDescription
ShRequiredObjectCan be a Chart or Worksheet object.


This example sorts the range A1:A100 on worksheet one when any sheet in the workbook is calculated.

Visual Basic for Applications
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    With Worksheets(1)
        .Range("a1:a100").Sort Key1:=.Range("a1")
    End With
End Sub