Protection Object Members

  • Article
Excel Developer Reference

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

Properties

  Name Description
Bb256124.properties(en-us,office.12).gif AllowDeletingColumns Returns True if the deletion of columns is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowDeletingRows Returns True if the deletion of rows is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowEditRanges Returns an AllowEditRanges object.
Bb256124.properties(en-us,office.12).gif 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.
Bb256124.properties(en-us,office.12).gif AllowFormattingCells Returns True if the formatting of cells is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowFormattingColumns Returns True if the formatting of columns is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowFormattingRows Returns True if the formatting of rows is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowInsertingColumns Returns True if the insertion of columns is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowInsertingHyperlinks Returns True if the insertion of hyperlinks is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowInsertingRows Returns True if the insertion of rows is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowSorting Returns True if the sorting option is allowed on a protected worksheet. Read-only Boolean.
Bb256124.properties(en-us,office.12).gif AllowUsingPivotTables Returns True if the user is allowed to manipulate pivot tables on a protected worksheet. Read-only Boolean.