Range.AllowEdit property (Excel)

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



expression A variable that represents a Range object.


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 
 ' Notify the user about editing cell A1. 
 If wksOne.Range("A1").AllowEdit = True Then 
 MsgBox "Cell A1 can be edited." 
 Msgbox "Cell A1 cannot be edited." 
 End If 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.