Protection Object Members

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.