ChartSheet.BeforeDoubleClick Event

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Occurs when the ChartSheet is double-clicked, before the default double-click action.

public:
 event Microsoft::Office::Interop::Excel::ChartEvents_BeforeDoubleClickEventHandler ^ BeforeDoubleClick;

event Microsoft.Office.Interop.Excel.ChartEvents_BeforeDoubleClickEventHandler BeforeDoubleClick;

member this.BeforeDoubleClick : Microsoft.Office.Interop.Excel.ChartEvents_BeforeDoubleClickEventHandler

Event BeforeDoubleClick As ChartEvents_BeforeDoubleClickEventHandler

Event Type

ChartEvents_BeforeDoubleClickEventHandler

Examples

The following code example demonstrates a handler for the BeforeDoubleClick event that displays a message box when an axis of the current Microsoft.Office.Tools.Excel.ChartSheet is double-clicked. The example also sets the Cancel parameter of the event handler to true so that the chart sheet does not receive the double click action when the user double-clicks an axis.

private void DisallowDoubleClicksOnAxis()
{
    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.BeforeDoubleClick +=
        new Excel.ChartEvents_BeforeDoubleClickEventHandler(
        ChartSheet1_BeforeDoubleClick);
}

void ChartSheet1_BeforeDoubleClick(int ElementID, int Arg1, 
    int Arg2, ref bool Cancel)
{
    if (ElementID == (int)Excel.XlChartItem.xlAxis)
    {
        MessageBox.Show("Formatting this axis is not allowed.");
        Cancel = true;
    }
}

Private Sub DisallowDoubleClicksOnAxis()
    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_BeforeDoubleClick(ByVal ElementID As Integer, _
    ByVal Arg1 As Integer, ByVal Arg2 As Integer, _
    ByRef Cancel As Boolean) Handles Me.BeforeDoubleClick
    If ElementID = Fix(Excel.XlChartItem.xlAxis) Then
        MsgBox("Formatting this axis is not allowed.")
        Cancel = True
    End If
End Sub

Remarks

The DoubleClick method does not cause this event to occur.

Applies to

Share via