In the spreadsheet with protection on
SS.protectSheet("Sheet1", {
selectCells: true,
formatCells: false,
formatRows: false,
formatColumns: false,
insertLink: false
})
a modal dialog is displayed whenever the user attempts to edit a locked cell, "The cell you're trying to change is protected...." How can I avoid that message? I'd rather the cell value just remain unchanged, or disallow the editor "focus" or edit mode.
The modal dialog is too disruptive to the UX. Suggestions