Sheet Unlock it self on Entry

[Fatekb]

Hello and thank for your help in advance.
I have a sheet that has the below vba code, the problem is that sheet will unlock itself every time I enter new entry on any section on that sheet.
and the if I change this line "Sheets("Sheet1").Unprotect Password:="abc" '<---- Change as required" to "Sheets("Sheet1").Protect " it will throw a debug and highlight
the line below with yellow
Range(Cells(6, Target.Column), Cells(20, Target.Column)).Find(Target.Value).Value = ""

* Kindly i need the sheet to stay protected at all times for the locked row and column.


This is the VBA code currently is in use .

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. I also moved your thread to the VBA subforum. --6StringJazzer

Please Login or Register  to view this content.

[6StringJazzer]

You are unprotecting the sheet to make a change, but you are not protecting it again when you finish. Add code as shown.

Please Login or Register  to view this content.

[Fatekb]

Sorry , now i got to know the code rule, my apology!