Spread 8.0 Documentation
SheetChanged Event
Support Options
ActiveX Reference > ActiveX Events > SheetChanged Event

Glossary Item Box

SheetChanged Event


See Also    Example

Applies To

fpSpread control

Description

Occurs when the user changes sheets by clicking a sheet tab.

Syntax

C++

afx_msg void OnSheetChangedfpSpread(UINT, int, CWnd*, LPVOID);

Visual Basic

Sub fpSpread_SheetChanged(OldSheet As Integer, NewSheet As Integer)

Parameters

The following parameters are available:

Parameter Description
OldSheet Sheet number of the previously active sheet
NewSheet Sheet number of the new active sheet

Remarks

The SheetChanged event occurs after the user changes the active sheet by clicking a sheet tab. The SheetChanging event occurs before the active sheet changes after the user clicks a sheet tab. Use the Cancel parameter in the SheetChanging event to cancel the change of the active tab if you want to do so.

See Also

SheetChanging event

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.