Protection Properties

Name

Returns

Description

AllowDeleting Columns

Boolean

Read-only. Returns whether the deletion of columns is allowed on a protected worksheet

AllowDeleting Rows

Boolean

Read-only. Returns whether the deletion of rows is allowed on a protected worksheet

AllowEdit Ranges

AllowEdit Ranges

Read-only. Returns an AllowEditRanges object

Name

Returns

Description

Allow Filtering

Boolean

Read-only. Returns whether the user is allowed to make use of an AutoFilter that was created before the sheet was protected

Allow

Formatting

Cells

Boolean

Read-only. Returns whether the formatting of cells is allowed on a protected worksheet

AllowFormatting Columns

Boolean

Read-only. Returns whether the formatting of columns is allowed on a protected worksheet

AllowFormatting Rows

Boolean

Read-only. Returns whether the formatting of rows is allowed on a protected worksheet

AllowInserting Columns

Boolean

Read-only. Returns whether the inserting of columns is allowed on a protected worksheet

AllowInserting Hyperlinks

Boolean

Read-only. Returns whether the inserting of hyperlinks is allowed on a protected worksheet

AllowInserting Rows

Boolean

Read-only. Returns whether the inserting of rows is allowed on a protected worksheet

AllowSorting

Boolean

Read-only. Returns whether the sorting option is allowed on a protected worksheet

AllowUsing PivotTables

Boolean

Read-only. Returns whether the manipulation of PivotTables is allowed on a protected worksheet

Was this article helpful?

0 0

Post a comment