I have never written code for Google App Script, so please excuse my ignorance.

I have a tab in Google Sheets named, “Attendants.” There is a Data Validation list in cell C9 of this tab. When the value of cell C9 changes, I’d like to run a code that checks the values in range V15:V650 and if the value of the cell is “Unhide” the entire row will be unhidden. If the value of the cell is “Hide” the entire row will be hidden. The value of these cells are driven by formulas. Please also note that I will need to protect this tab as well, so I am not sure if I would alsoz need to unprotect the sheet prior to running any script.

In my experience with VBA, I know some code can take longer to run. If it is more efficient, the script could possibly first hide rows 15:650 and then find the first instance of the value “Unhide” and then unhide that row and the 14 rows below it.

If anyone would be able to provide me with code to make this work, I’d be immensely grateful.