Skip to main content

TdxSpreadSheetSheetProtectionOptions.AllowSelectUnlockedCells Property

Specifies if an end-user can select cells in a protected worksheet.

Declaration

property AllowSelectUnlockedCells: Boolean index 10 read; write; default True;

Property Value

Type Default
Boolean True

Remarks

This property corresponds to the Select unlocked cells checkbox in the Protect Sheet dialog:

The Protect Sheet Dialog

Set the AllowSelectUnlockedCells property to False or True to forbid or allow an end-user to select unlocked cells within a protected worksheet. Setting this property to False automatically sets the AllowSelectLockedCells property to False. Therefore, if you forbid selecting unlocked cells, an end-user is able to select no cell within a protected worksheet.

Setting the AllowSelectUnlockedCells property back to True does not affect the AllowSelectLockedCells property value.

To identify if an end-user is currently able to select cells, use the ActualAllowSelectUnlockedCells property.

The default value of the AllowSelectUnlockedCells property is True.

See Also