Protection Members (Excel)

Contribute to this content

Represents the various types of protection options available for a worksheet.

Properties

Name	Description
AllowDeletingColumns	Returns True if the deletion of columns is allowed on a protected worksheet. Read-only Boolean.
AllowDeletingRows	Returns True if the deletion of rows is allowed on a protected worksheet. Read-only Boolean.
AllowEditRanges	Returns an AllowEditRanges object.
AllowFiltering	Returns True if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. Read-only Boolean.
AllowFormattingCells	Returns True if the formatting of cells is allowed on a protected worksheet. Read-only Boolean.
AllowFormattingColumns	Returns True if the formatting of columns is allowed on a protected worksheet. Read-only Boolean.
AllowFormattingRows	Returns True if the formatting of rows is allowed on a protected worksheet. Read-only Boolean.
AllowInsertingColumns	Returns True if the insertion of columns is allowed on a protected worksheet. Read-only Boolean.
AllowInsertingHyperlinks	Returns True if the insertion of hyperlinks is allowed on a protected worksheet. Read-only Boolean.
AllowInsertingRows	Returns True if the insertion of rows is allowed on a protected worksheet. Read-only Boolean.
AllowSorting	Returns True if the sorting option is allowed on a protected worksheet. Read-only Boolean.
AllowUsingPivotTables	Returns True if the user is allowed to manipulate pivot tables on a protected worksheet. Read-only Boolean.