'Setting cells in google sheets as read-only without locking its column width?
Protecting a range in google sheet also locks the cell's column width. I would like to make a cell read-only but still allow the user to resize the column width if necessary. Is there a way to do this via google scripts?
Solution 1:[1]
This is the current feature of Protect a sheet or range. Once it's protected, it's locked. You'll get this prompt if you try to touch it:
Solution 2:[2]
Workaround:
You can instruct the readonly user to download the file. They can then change the column width.
It's awful, but it's the best solution I've found.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | noogui |
| Solution 2 | cowlinator |