Unlock 1 cell To Allow Displaying value

[chuck.balogh]

Hi there. I have a script that I have been using for a while. I would like it to be more secure (from me....LOL) as I often am not paying attention and type over "read only" fields. My spreadsheet has 1 input cell and an input button. The button runs the script. The script allows the user to enter a word, then writes the word back to another cell to display it to the user. I currently have all cells locked in the spreadsheet except the Input cell and the "entered word" cell (i.e two cells unlocked). I would like to be able to lock the "entered word" cell but don't know how to disable the protection to do so in the script.

Any help would be appreciated. Be kind, I am a very infrequent, novice script writer. LOL

[AlphaFrog]

Try something like this. Change the Password and 'entered word' cell to suit.

Please Login or Register  to view this content.

Pro TIP: you can get example code by recording a macro and doing the steps.

[chuck.balogh]

Thanks. I will give this a try later this evening. Thanks again.

[chuck.balogh]

I couldn't resist.....I tried it and it works great. Thanks so much.