Winnovative Excel Library

ExcelProtectionAllowFlags Enumeration

Winnovative Excel Library Documentation
The allowed operations for a protected worksheet.

Namespace:  Winnovative.ExcelLib
Assembly:  wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax

[FlagsAttribute]
public enum ExcelProtectionAllowFlags
Members

  Member nameValueDescription
NoProtection0 The worksheet has no protection options.
AllowDefault17408 The default protection allow selection of locked and unlocked cells
AllowNone16384 No operation is allowed on a protected worksheet except selecting unlocked cells.
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
AllowSelectLockedCells1024 Allow select locked cells.
AllowSort2048 Allow sort.
AllowUseAutoFilter4096 Allow use Auto Filter
AllowUsePivotTable8192 Allow use Pivot Tables.
AllowSelectUnlockedCells16384 Allow select unlocked cells.
AllowAll32767 All operations are allowed for a protected worksheet.
See Also

Reference