macro for message box, then lock cells after name is entered

[stressler]

Good morning. I need a macro that would give me a message box and then lock my cell after a name is entered in the cell. As an example. If I have a blank cell, always in row 1, column C:AA, then when a name is entered in that cell, a message box will pop up, asking the user if they want to accept the signature or not, if they select yes, I want the cell to save the name and password protect that cell so that it cannot be changed unless you enter the password. If the user selects no to the message box question, I want the message box to close and the cell to remain enabled and editable without password protecting it. So the password protection is triggered by a yes response to the question, any other response would not trigger the password protection to that cell.

 

[stressler]

Okay, perhaps I asked for too much within 1 request.

Let me ask this general question instead. Is there a way to have a cell password protected by the user selecting the Yes answer from a msgbox question?