So I have to sheets/panes in a Google Sheet. My "Settings"-sheet includes a number of checkboxes.
What I want, is to be able to show/hide specific columns in my second sheet, based on the true/false state of these checkboxes.
Idea is that each checbox will correspond to a specific column in the second sheet.
I know how to do this in Excel, but I have virtually NO experience in Google Apps Script, other than what I have been able to Google this morning.
Can anyone help me by pointing me on the right path?
For reference, the Visual Basics script I use for the same function in Excel is included below:
Private Sub CheckBox17_Click() ['Competitive Matrix (EMEA NE)'!S:S].EntireColumn.Hidden = Not CheckBox17 End Sub
Aucun commentaire:
Enregistrer un commentaire