Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet1.Unprotect Password:="12345"
If ActiveCell.Value <> "" Then
Target.Locked = True
Sheet1.Protect Password:="12345"
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet1.Unprotect Password:="12345"
If ActiveCell.Value <> "" Then
Target.Locked = True
Sheet1.Protect Password:="12345"
End If
End Sub