function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menuEntries =[]; menuEntries.push({name: "1. dupliquer feuille Active", functionName: "simpleduplicatesheet"}); menuEntries.push(null); menuEntries.push({name: "2. supprimer feuille Active", functionName: "supprimersheet"}); ss.addMenu("🎁menuProf🎁", menuEntries); } function simpleduplicatesheet(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); sheet = ss.getActiveSheet(); for (var i=1 ;i<=31;i++){ sheet2 = sheet.copyTo(ss).setName(i); } } function supprimersheet(){ var classeur = SpreadsheetApp.getActiveSpreadsheet(); var ss = SpreadsheetApp.getActive(); var nb = classeur.getNumSheets(); var feuilles = classeur.getSheets(); for (var i=1 ;i