Public Sub Worksheet_Activate()
Dim Rng As Range, sh As Object
For Each sh In Sheets
With sh
.Unprotect Password:="123"
.Unprotect
.Columns("A:I").Locked = False
For Each Rng In .Range("A1:A" & .Range("A65536").End(3).Row)
If Rng.Value < Date Then .Cells(Rng.Row, "A").Resize(, 9).Locked = True
Next
.Protect Password:="123"
End With
Next
End Sub
Public Sub Worksheet_Activate()
Dim Rng As Range, sh As Object
For Each sh In Sheets
With sh
.Unprotect Password:="123"
.Unprotect
.Columns("A:I").Locked = False
For Each Rng In .Range("A1:A" & .Range("A65536").End(3).Row)
If Rng.Value < Date Then .Cells(Rng.Row, "A").Resize(, 9).Locked = True
Next
.Protect Password:="123"
End With
Next
End Sub