Table of Contents

TSheetProtectionOptions Class

Options for protecting a sheet.

Syntax

Namespace: FlexCel.Core

public sealed class TSheetProtectionOptions

Constructors

Properties

Name Description
Contents Sheet contents are protected
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.
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.
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.
RowFormatting 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.
InsertRows 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.
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.
SelectLockedCells 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.
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.
SelectUnlockedCells If TRUE, users are allowed to change this setting. Set it to FALSE to disable this property. Only on Excel >= XP.