Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ChartSheetBase.ActivateEvent Event

Occurs when the Microsoft.Office.Tools.Excel.ChartSheetBase is activated.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public event ChartEvents_ActivateEventHandler ActivateEvent

The following code example demonstrates a handler for the ActivateEvent event that displays a message box when the current Microsoft.Office.Tools.Excel.ChartSheetBase is activated.

private void DisplayWhenActivated()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    this.ActivateEvent +=
        new Excel.ChartEvents_ActivateEventHandler(
        ChartSheet1_ActivateEvent);
}

void ChartSheet1_ActivateEvent()
{
    MessageBox.Show("The chart sheet was was activated.");
}

Show:
© 2015 Microsoft