How to Show a Warning Message When Editing Cells
If you’d rather people still be able to edit the cells, but instead have a warning message for anyone who tries to edit specific cells, you can do that as well.
From your Sheets document, head back to Data > Protected Sheets and Ranges in the toolbar.
Next, click the permission rule you want to alter.
Click “Set Permissions.”
Select “Show a warning when editing this range” and then click “Done.”
The next time anyone tries to edit any of the protected cells, they’re prompted with this message instead:
No comments:
Post a Comment