Worksheet.Protection Property

Syntax

expression.Protection

expression A variable that represents a Worksheet object.

Example

This example protects the active worksheet and then determines if columns can be inserted on the protected worksheet, notifying the user of this status.

Visual Basic for Applications

Visual Basic for Applications
`Sub CheckProtection() ActiveSheet.Protect ' Check the ability to insert columns on a protected sheet. ' Notify the user of this status. If ActiveSheet.Protection.AllowInsertingColumns = True Then MsgBox "The insertion of columns is allowed on this protected worksheet." Else MsgBox "The insertion of columns is not allowed on this protected worksheet." End If End Sub`

Sub CheckProtection() ActiveSheet.Protect ' Check the ability to insert columns on a protected sheet. ' Notify the user of this status. If ActiveSheet.Protection.AllowInsertingColumns = True Then MsgBox "The insertion of columns is allowed on this protected worksheet." Else MsgBox "The insertion of columns is not allowed on this protected worksheet." End If End Sub

protection protection property

Returns a Protection object that represents the protection options of the worksheet.

See also: