Whether or not double clicking an unprotected cell puts it into edit mode.

Usage

Set_Property(OLECtrlEntID, "OLE.DblClickToEdit", Boolean)

Values

[True | False]

Default: True

Remarks

The DblClickToEdit property determines if double clicking a cell puts it into edit mode. There are three ways for a user to enter edit mode in an unprotected cell. They can start typeing while a cell is selected, press the EDIT function key (see the FunctionKey property), or double-click in a cell.

If you want to allow the user to edit a cell, but you also want to perform a separate action on a double click, set this property to FALSE. Doing so will still allow the user to enter into edit mode via the first two methods described above.

If you do not want the user to edit a cell at all, use the CellProtection property.

Example

// Do not allow users to edit a cell by double clicking  
Set_Property(@Window:".OLE_EDITTABLE", "OLE.DblClickToEdit", 0)  

// Allow users to edit a cell by double clicking  
Set_Property(@Window:".OLE_EDITTABLE", "OLE.DblClickToEdit", 1)

See Also

FunctionKeyCellProtection

  • No labels