Table of Contents

TSheetProtectionOptions Record

Options for protecting a sheet.

Syntax

Unit: FlexCel.Core

TSheetProtectionOptions = record;

Fields

Name Description
CellFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
ColumnFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
Contents Sheet contents are protected
DeleteColumns If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
DeleteRows If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
EditAutoFilters If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
EditPivotTables If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
InsertColumns If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
InsertHyperlinks If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
InsertRows If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
Objects If TRUE, objects on the sheet are protected. Note that this setting behaves like Scenarios and opposite from all the rest.
In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed.
RowFormatting If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
Scenarios If TRUE, scenarios on the sheet are protected. Note that this setting behaves like Objects and opposite from all the rest.
In the other settings, FALSE means that the setting is protected, TRUE that the setting can be changed.
SelectLockedCells If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
SelectUnlockedCells If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.
SortCellRange If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.

Methods

Name Description
Create Overloaded
 Create
Create(Boolean)
Create(TProtectionType)

Operators

Name Description
Equality Adapts the = operator so it returns true when both instances have the same values.
Inequality Adapts the <> operator so it returns true when both instances have different values.