Protection Property
Returns a Protection object that contains the protection properties for the specified worksheet. The protection properties are ignored if the Enabled property is set to False.
expression.Protection
*expression * Required. An expression that returns a Worksheet object.
Example
This example locks the cells in column B and enables protection for the sheet.
Sub ProtectColumnB()
' Unlock all of the cells in the active sheet.
Spreadsheet1.ActiveSheet.Cells.Locked = False
' Lock the cells in column B.
Spreadsheet1.Columns(2).Locked = True
' Protect the locked cells.
Spreadsheet1.ActiveSheet.Protection.Enabled = True
End Sub
Applies to | Worksheet Object
See Also | AllowDeletingColumns Property | AllowDeletingRows Property | AllowFiltering Property | AllowInsertingColumns Property | AllowInsertingRows Property | AllowSorting Property | Protection Object