ViewChange Event
ViewChange event as it applies to the ChartSpace object.
Occurs whenever the chart is redrawn.
Private Sub Object _ViewChange( )
Object The name of the ChartSpace object that you are trapping this event for.
ViewChange event as it applies to the PivotTable object.
Occurs whenever the PivotTable list is redrawn.
Private Sub Object _ViewChange(ByVal Reason As PivotViewReasonEnum)
Object The name of the PivotTable object that you are trapping this event for.
Reason The PivotViewReasonEnum constant that indicates how the view was changed.
ViewChange event as it applies to the Spreadsheet object.
Occurs whenever the spreadsheet is redrawn.
Private Sub Object _ViewChange(ByVal Target As Range)
Object The name of the Spreadsheet object that you are trapping this event for.
Target The currently visible range.
Remarks
For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript.