I found a script (on this post: I need to hide/show a group of columns in Google Sheets in a simple way ) that adds a dropdown menu with two options: Show Range X of Columns & Hide Range X of Columns. The script works perfectly, except that I am unable to add more menu options for different column ranges.
I have tried modifying the code (see below). Currently, the "Show/Hide Columns" dropdown menu shows two options: "Show UTH" & "Hide UTH", but the "Show Viz" & "Hide Viz" options are being ignored. Any suggestions on how to modify the code so I can to add multiple show & hide buttons to the menu that affect different column ranges? I'm very new to Google Scripts, so I'm hoping there's something very simple that I'm overlooking.
function onOpen(Viz) {
var menu = [{name: "Show Viz", functionName: "showColumns"}, {name: "Hide Viz", functionName: "hideColumns"}]
SpreadsheetApp.getActiveSpreadsheet().addMenu("Show/Hide Columns", menu);
}
function showColumns(Viz) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.showColumns(4);
sheet.showColumns(12);
sheet.showColumns(20);
}
function hideColumns(Viz) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.hideColumns(4);
sheet.hideColumns(12);
sheet.hideColumns(20);
}
function onOpen(UTH) {
var menu = [{name: "Show UTH", functionName: "showColumns"}, {name: "Hide UTH", functionName: "hideColumns"}]
SpreadsheetApp.getActiveSpreadsheet().addMenu("Show/Hide Columns", menu);
}
function showColumns(UTH) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.showColumns(5);
sheet.showColumns(13);
sheet.showColumns(21);
}
function hideColumns(UTH) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.hideColumns(5);
sheet.hideColumns(13);
sheet.hideColumns(21);
}