Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is activated.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Event ActivateEvent As ChartEvents_ActivateEventHandler
'Usage
Dim instance As ChartSheet
Dim handler As ChartEvents_ActivateEventHandler
AddHandler instance.ActivateEvent, handler
public event ChartEvents_ActivateEventHandler ActivateEvent
public:
event ChartEvents_ActivateEventHandler^ ActivateEvent {
void add (ChartEvents_ActivateEventHandler^ value);
void remove (ChartEvents_ActivateEventHandler^ value);
}
JScript does not support events.
Examples
The following code example demonstrates a handler for the ActivateEvent event that displays a message box when the current Microsoft.Office.Tools.Excel.ChartSheet is activated.
Private Sub DisplayWhenActivated()
Globals.Sheet1.Range("A1", "A5").Value2 = 22
Globals.Sheet1.Range("B1", "B5").Value2 = 55
Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
Me.ChartType = Excel.XlChartType.xl3DColumn
End Sub
Sub ChartSheet1_ActivateEvent() Handles Me.ActivateEvent
MsgBox("The chart sheet was was activated.")
End Sub
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.");
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.