Range.AllowEdit property (Excel)

Returns a Boolean value that indicates if the range can be edited on a protected worksheet.

Syntax

expression.AllowEdit

expression A variable that represents a Range object.

Example

In this example, Microsoft Excel notifies the user whether cell A1 can be edited on a protected worksheet.

Sub UseAllowEdit() 
 
 Dim wksOne As Worksheet 
 
 Set wksOne = Application.ActiveSheet 
 
 ' Protect the worksheet 
 wksOne.Protect 
 
 ' Notify the user about editing cell A1. 
 If wksOne.Range("A1").AllowEdit = True Then 
 MsgBox "Cell A1 can be edited." 
 Else 
 Msgbox "Cell A1 cannot be edited." 
 End If 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.