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
Bookmarks