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 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