1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| function onOpen() {
var menu = [{name: "Afficher PROJET 1", functionName: "showRows"}, {name: "Masquer PROJET 1", functionName: "hideRows"}, {name: "Afficher PROJET 2", functionName: "showRows"}, {name: "Masquer PROJET 2", functionName: "hideRows"}]
SpreadsheetApp.getActiveSpreadsheet().addMenu("📱 Mon Menu 📱", menu);
}
function showRows() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.showRows(7,11); //Afficher PROJET 1
}
function hideRows() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.hideRows(7,11); //Masquer PROJET 1
}
function showRows() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.showRows(13,16); //Afficher PROJET 2
}
function hideRows() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.hideRows(13,16); //Masquer PROJET 2
}; |
Partager