Range.AllowEdit property

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