I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. This works great to keep the formulas safe. However, when the other users view a protected range, it is covered in a distracting gray hatch-striping.

I would really like these protected cells to appear without the stripe pattern for the other users. Is there a way to turn off this special formatting for protected ranges?

1 Answer 1


Based on Uncheck view protected range from google script macro it looks as though you might either have to risk accidental deletion/overwriting, have other users suffer the distraction or uncheck "Protected Range" in the view menu. A suggestion was to "Include an image with screenshotted text that tells them to goto View > Protected Ranges".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.