ViewChange Event

ViewChange event as it applies to the ChartSpace object.

Occurs whenever the chart is redrawn.

Private SubObject**_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 SubObject**_ViewChange**(ByValReasonAsPivotViewReasonEnum)

*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 SubObject**_ViewChange**(ByValTargetAsRange)

*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 .

Applies to | ChartSpace Object | PivotTable Object | Spreadsheet Object