Skip to main content

Range.AllowEdit property

Table of contents
  1. Syntax
  2. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>