AllowEdit Property

True if the user is allowed access to the specified range on a protected worksheet. Read/write Boolean.

expression.AllowEdit

expression    Required. An expression that returns a UserAccess object.

True if the range can be edited on a protected worksheet. Read-only Boolean.

expression.AllowEdit

expression    Required. An expression that returns a Range object.

In this example, Microsoft Excel notifies the user if cell A1 can be edited or not 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