Back to Browse

Google Sheets: Lock Cell After Edit

56.6K views
Oct 19, 2020
3:23

How to lock a single cell after that cell is edited. Important note: * Neither the owner nor the user triggering the script lose permissions with this script Sheet (to copy) https://docs.google.com/spreadsheets/d/1iH1-HhflzF5fL7aiyqYQwFdDHBwUQNessUk8jTi3Rpw/edit#gid=0 Script: function onEdit(e){ let protection = e.range.protect(); protection.removeEditors(protection.getEditors()); if (protection.canDomainEdit()) { protection.setDomainEdit(false); } }

Download

1 formats

Video Formats

360pmp44.1 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Google Sheets: Lock Cell After Edit | NatokHD