Make a copy of a sheet with sheet-level protections in the same spreadsheet. This does NOT affect the behavior of any built-in tools or menus and only works when the copy is triggered by the script
Sheet (make a copy from the File menu)
docs.google.com/spreadsheets/d/14HB-RDPq1f7bVUjsv1cyM4w9JqVgl_mCGFFK9Xu5cCc/edit?gid=0#gid=0
Script (the array.map version is in the script on the file but arrow functions cannot be in a RUclips description):
function copyWithProtections(){
const sh = SpreadsheetApp.getActiveSpreadsheet();
const ss = sh.getSheetByName("Template");
const prot = ss.getProtections(SpreadsheetApp.ProtectionType.SHEET)
let nSheet = ss.copyTo(sh).setName(sh.getNumSheets()-1);
let p ...