Like many others I am trying to allow the average user to hide rows in a spreadsheet that has an entire protected column. Currently, they are denited because hiding is considered editing.

From this thread, it sounds unsolvable: Filtering a protected column

I found this description of a macro written in VBA that allows this functionality in Excel: https://stackoverflow.com/questions/31189781/lock-cells-in-excel-but-still-allow-to-show-hide

Is it possible to write a similar script that would work in Google Sheets?

  • Welcome. Please describe what the referred code does and what you already tried. – Rubén Oct 29 at 22:33
  • Hi! Thanks. The referred code seems to allow for levels of functionality like hiding or filtering while maintaining the permissions lock on the cell. Basically, I want users to be able to hide rows even if they contain cells that are in the protected column that cannot be edited. – Matthew Sanders Oct 31 at 16:58
  • Please edit the question to add all the relevant details to it. – Rubén Oct 31 at 17:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.