Excel VBA to lock cell from being edited

[Stuepef]

I have a cell in Sheet1 (code name) that I would lock from being edited followed by the use of being prompted to enter a password. Here are the details:

Sheet1 cell C2 locked from being edited, then enter password to inhibit users from just manually unlocking the cell.

Thank you!

 

[mumps]

Do you want to lock C2 after some data has been entered in that cell? Also, do you want to allow data entry in all the other cells?