function protectOnEdit(event) { var ss = SpreadsheetApp.getActive(); var range = ss.getRange('Statutory Comp Jan-23to Dec-23!D6:E10'); var timeZone = Session.getScriptTimeZone(); var stringDate = Utilities.formatDate(new Date(), timeZone, '13/12/22 15:10'); var description = 'Protected on ' + stringDate; var protection = range.protect().setDescription(description); // below code taken directly from Google's documentation var me = Session.getEffectiveUser(); protection.addEditor(me); protection.removeEditors(protection.getEditors()); if (protection.canDomainEdit()) { protection.setDomainEdit(false); } }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter