Range.AllowEdit Property

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

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").AllowEdit = True Then MsgBox "Cell A1 can be edited." Else Msgbox "Cell A1 cannot be edited." End If End Sub`

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

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

See also: