ActiveSheetChanging Event (GcSpreadSheet)

Visual Basic
C#

'Declaration
 
Public Event ActiveSheetChanging As System.EventHandler(Of CancelEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of CancelEventArgs)
 
AddHandler instance.ActiveSheetChanging, handler

public event System.EventHandler<CancelEventArgs> ActiveSheetChanging

The event handler receives an argument of type System.ComponentModel.CancelEventArgs containing data related to this event. The following CancelEventArgs properties provide information specific to this event.

Property	Description
Cancel

This example uses the ActiveSheetChanging event.

C#

gcSpreadSheet1.SheetCount = 2;

private void gcSpreadSheet1_ActiveSheetChanged(object sender, EventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanged");
        }

private void gcSpreadSheet1_ActiveSheetChanging(object sender, System.ComponentModel.CancelEventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanging");            
        }

VB.NET

GcSpreadSheet1.SheetCount = 2

Private Sub GcSpreadSheet1_ActiveSheetChanged(sender As System.Object, e As System.EventArgs) Handles GcSpreadSheet1.ActiveSheetChanged
        ListBox1.Items.Add("ActiveSheetChanged")
    End Sub

    Private Sub GcSpreadSheet1_ActiveSheetChanging(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles GcSpreadSheet1.ActiveSheetChanging
        ListBox1.Items.Add("ActiveSheetChanging")
    End Sub

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GcSpreadSheet Class
GcSpreadSheet Members