This documentation is archived and is not being maintained.

ViewChange Event

Office 2003

Occurs whenever the chart is redrawn.

Private Sub Object _ViewChange( )

Object       The name of the ChartSpace object that you are trapping this event for.

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.

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 .





Show: