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
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment