Excel VBA

Hi,

I posted the VBA at the bottom of the screen... it works for a while then stops... now it only works on row one and none of the rest..

I followed this website https://www.extendoffice.com/documents/excel/3778-excel-lock-cell-after-data-entry-input.html

regards

Andrew

Dim mRg As Range
Dim mStr As String

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Range("A1:I1000"), Target) Is Nothing Then
Set mRg = Target.Item(1)
mStr = mRg.Value
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim xRg As Range
On Error Resume Next
Set xRg = Intersect(Range("A1:I1000"), Target)
If xRg Is Nothing Then Exit Sub
Target.Worksheet.Unprotect Password:="HICA"
If xRg.Value <> mStr Then xRg.Locked = True
Target.Worksheet.Protect Password:="HICA"
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("A1:I1000"), Target) Is Nothing Then
Set mRg = Target.Item(1)
mStr = mRg.Value
End If
End Sub