Export (0) Print
Expand All
Expand Minimize

Range.AllowEdit Property

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

End Sub



Community Additions

ADD
Show:
© 2014 Microsoft