DataEntryMode Property Example

This example turns off Data Entry mode if it's on.

If (Application.DataEntryMode = xlOn) Or _
    (Application.DataEntryMode = xlStrict) Then
        Application.DataEntryMode = xlOff
End If