CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user1808001
user1808001

Reputation: 31

Uncheck view protected range from Google Apps Script macro

I have a Google Spreadsheet with a protected range. The data is hard to read because of the hash marks. I can fix the problem manually by unchecking "Protected Range" in the view menu. Can I do the same thing from a macro?

Upvotes: 3

Views: 1730

Answers (2)

Mogsdad
Mogsdad

Reputation: 45710

It is what it is.

From the documentation:

Collaborators who try to edit a cell in a protected range they don’t have edit access to will receive an error message. When opening a spreadsheet with protected ranges, individuals will see ranges they don’t have edit access to displayed with a checkered background. If the background pattern makes it difficult to read spreadsheet content, you can hide protected ranges by pointing your mouse to the View menu and unchecking Protected Ranges.

Upvotes: 1

harvest316
harvest316

Reputation: 1411

Bad news, I'm afraid. I just spent an hour searching for the same answer myself, and I don't think there is one!

Workaround: Include an image with screenshotted text that tells them to goto View > Protected Ranges.

Or just trust them not to frig with your sheet. You can always rollback history.

Upvotes: 1

Related Questions