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 worksheet is double-clicked, before the default double-click action.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Event BeforeDoubleClick As DocEvents_BeforeDoubleClickEventHandler
public event DocEvents_BeforeDoubleClickEventHandler BeforeDoubleClick
Remarks
This event does not occur when the user double-clicks the border of a cell.
Examples
The following code example demonstrates a handler for the BeforeDoubleClick event that cancels the double-click action on the current worksheet. The event handler informs the user that double-clicking is not allowed for the worksheet, and then sets the Cancel parameter of the DocEvents_BeforeDoubleClickEventHandler event handler to true so that Microsoft Office Excel cancels the double-click action.
This example is for a document-level customization.
Sub Worksheet1_BeforeDoubleClick(ByVal Target As Excel.Range, _
ByRef Cancel As Boolean) Handles Me.BeforeDoubleClick
MsgBox("Double-clicking in this sheet is not allowed.")
Cancel = True
End Sub
private void WorksheetBeforeDoubleClick()
{
this.BeforeDoubleClick +=
new Excel.DocEvents_BeforeDoubleClickEventHandler(
Worksheet1_BeforeDoubleClick);
}
void Worksheet1_BeforeDoubleClick(Excel.Range Target,
ref bool Cancel)
{
MessageBox.Show("Double-clicking in this sheet" +
" is not allowed.");
Cancel = true;
}
.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.