Excel.Worksheet.Protection.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.Protection property (Excel)	vbaxl10.chm175154	vbaxl10.chm175154	Excel.Worksheet.Protection	46bf2025-46cf-81ae-4864-2d6266dab173	05/30/2019	medium

Worksheet.Protection property (Excel)

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

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.

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

[!includeSupport and feedback]