Calculate Event [Excel 2003 VBA Language Reference]

Occurs after the chart plots new or changed data, for the Chart object. Occurs after the worksheet is recalculated, for the Worksheet object.

Private Sub*object_*Calculate()

objectChart or Worksheet. For information about using events with the Chart object, see Using Events with Embedded Charts.

Example

This example adjusts the size of columns A through F whenever the worksheet is recalculated.

Private Sub Worksheet_Calculate()
    Columns("A:F").AutoFit
End Sub

Applies to | Chart Object | Worksheet Object