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

Glossary Item Box

SheetChanging Event


See Also    Example

Applies To

fpSpread control

Description

Occurs before the active sheet changes when the user clicks a sheet tab.

Syntax

C++

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

Visual Basic

Sub fpSpread_SheetChanging(OldSheet As Integer, NewSheet As Integer, Cancel As Long)

Parameters

The following parameters are available:

Parameter Description
OldSheet Sheet number of the previously active sheet
NewSheet Sheet number of the new active sheet if change occurs
Cancel Lets you cancel the change of the active sheet
Set to 1 to cancel the change.

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 to cancel the change of the active tab if you want to do so.

See Also

SheetChanged event

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