SheetChanging Event
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