Class Protection (Excel VBA)

The class Protection represents the various types of protection options available for a worksheet.

Set

To use a Protection class variable it first needs to be instantiated, for example

Dim prt as Protection
Set prt = ActiveSheet.Protection

Protection class variables can be set using the Worksheet.Protection procedure.

Themes

The following procedures in this class have been grouped together and are described on a separate theme page

Allow with its procedures AllowDeletingColumns, AllowDeletingRows, AllowEditRanges, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowSorting and AllowUsingPivotTables

Properties

AllowFiltering returns True if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.

AllowInsertingHyperlinks returns True if the insertion of hyperlinks is allowed on a protected worksheet.