Protection Members (Excel)

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

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.

Show:
© 2015 Microsoft