ExcelProtectionAllowFlags Enumeration

The allowed operations for a protected worksheet.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 12.0.0
C#
[FlagsAttribute]
public enum ExcelProtectionAllowFlags

Members

NoProtection0 The worksheet has no protection options.
AllowEditObjects1 Allow edit objects.
AllowEditScenarios2 Allow edit scenarios.
AllowFormatCells4 Allow format cells.
AllowFormatColumns8 Allow format columns.
AllowFormatRows16 Allow format rows.
AllowInsertColumns32 Allow insert columns.
AllowInsertRows64 Allow insert rows.
AllowInsertHyperlinks128 Allow insert hyperlinks.
AllowDeleteColumns256 Allow delete columns
AllowDeleteRows512 Allow delete rows
AllowSelectLockedCells1,024 Allow select locked cells.
AllowSort2,048 Allow sort.
AllowUseAutoFilter4,096 Allow use Auto Filter
AllowUsePivotTable8,192 Allow use Pivot Tables.
AllowNone16,384 No operation is allowed on a protected worksheet except selecting unlocked cells.
AllowSelectUnlockedCells16,384 Allow select unlocked cells.
AllowDefault17,408 The default protection allow selection of locked and unlocked cells
AllowAll32,767 All operations are allowed for a protected worksheet.

See Also