Range.AllowEdit Property

Excel Developer Reference

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.

Visual Basic for Applications
  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").<strong>AllowEdit</strong> = True Then
    MsgBox "Cell A1 can be edited."
Else
    Msgbox "Cell A1 cannot be edited."
End If

End Sub

See Also