A cell's protection level.
Usage
Set_Property(OLECtrlEntID, "OLE.CellProtection[field; record]", OptionValue)
Values
OptionValue can be set to one of the following valid options:
| Value | Abbr. | Description |
|---|---|---|
| Full | FUL | Full protection; the user cannot select the cell or edit it |
| Selectable | SEL | Selectable protection; the user can select the cell but cannot edit it |
| Read Only | RO | Read only protection; the user can select the cell or enter into edit mode, but the user cannot modify its contents |
| None | NONE | No protection; the user can select and edit the cell |
Default: None
Indices
| Index | Description |
|---|---|
| field | Index to an existing field |
| record | Index to an existing record |
Remarks
The CellProtection property allows you to establish several levels of security in a cell.
Fully protected cells are good for representing symbolics. Since they can never be selected, a user can skip straight to the next editable cell without having to tab through symbolics. Selectable protected cells allow a user to select a cell but not to edit it. This is useful for edit tables that only display a list of non-editable options from which a user can select.
Read Only protected cells allow a user select a cell and enter into edit mode, but the user cannot modify the contents even in edit mode. This allows a user to select portions of text for Copy/Paste operations rather than having to Copy the whole thing.
By default, cells have no protection and this property's value is "None." Without protection, a user can select and edit the cell. This will be the case for most edit tables containing record data.
In addition to specifying the above options, you can optionally use number representing protections levels:
| Num | Protection |
|---|---|
| 0 | None |
| 1 | Full |
| 2 | Selectable |
| 3 | Read Only |
