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 selection moves away from the Chart control, causing the Chart control to become deactivated.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Event Deactivate As ChartEvents_DeactivateEventHandler
'Usage
Dim instance As Chart
Dim handler As ChartEvents_DeactivateEventHandler
AddHandler instance.Deactivate, handler
public event ChartEvents_DeactivateEventHandler Deactivate
public:
event ChartEvents_DeactivateEventHandler^ Deactivate {
void add (ChartEvents_DeactivateEventHandler^ value);
void remove (ChartEvents_DeactivateEventHandler^ value);
}
JScript does not support events.
Examples
The following code example creates a Chart with a handler for the Deactivate event that displays a message box when the chart is deactivated.
WithEvents DeactivateChart As Microsoft.Office.Tools.Excel.Chart
Private Sub DisplayWhenDeactivated()
Me.Range("A1", "A5").Value2 = 22
Me.Range("B1", "B5").Value2 = 55
DeactivateChart = Me.Controls.AddChart(Me.Range("D2", "H12"), _
"DeactivateChart")
DeactivateChart.SetSourceData(Me.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
DeactivateChart.ChartType = Excel.XlChartType.xl3DColumn
End Sub
Sub DeactivateChart_Deactivate() Handles DeactivateChart.Deactivate
MsgBox("The chart was deactivated.")
End Sub
private void DisplayWhenDeactivated()
{
this.Range["A1", "A5"].Value2 = 22;
this.Range["B1", "B5"].Value2 = 55;
Microsoft.Office.Tools.Excel.Chart chart1 =
this.Controls.AddChart(this.Range["D2", "H12"],
"chart1");
chart1.SetSourceData(this.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
chart1.ChartType = Excel.XlChartType.xl3DColumn;
chart1.Deactivate +=
new Excel.ChartEvents_DeactivateEventHandler(
chart1_Deactivate);
}
void chart1_Deactivate()
{
MessageBox.Show("The chart was deactivated.");
}
.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.