Gooru Tip - Maximize the video player and adjust video quality for optimal viewing!
A new feature just released for Google Spreadsheets, Protected Ranges allows you to select a range of cells and choose which collaborators have permission to edit those cells, and which collaborators should only be able to view those cells.
Very powerful! This goes hand in hand with the use of Named Ranges, which I cover in my next video.
Awesome, very informative. I like these newer videos that give us more insight to new features that we usually wouldn’t have stumbled upon. More videos like this, please.
Thanks! This update in particular (along w/ Named Ranges, video coming tomorrow) is really interesting to me.
Any idea how I can protect a range from “Anyone with the Link” rather than a specific person. It seems if it’s open to anyone with the link can edit, they can edit the whole sheet, and protection doesn’t work. I don’t want to go through and grant each user permission, as there will be many users.
As explained in the video collaborators can go in View and un-check ‘Protected ranges’ to hide the grey dotted background from protected ranges.
Is there a way to make that change permanent? It seems this ‘Protected ranges’ feature is always checked by default when re-opening the spreadsheet.
Thanks!
Cedric,
Unfortunately, there is not a way to make that change permanent.
Sorry!
Hi,
I’ve created some scripts that enter values in some cells. And I’d like to make these cells editable only through this scripts.
I’ve tried this “Protecting Cell Ranges” but it also blocks all the scripts that tries to change any value in those cells, giving the user a “Access denied” msg.
So is there a way to do that? block a cell from a user but allow him to edit it only through scripting???
That would be really helpfull.
thanks in advance.
Hey,
I’m not sure if you can do that, but I really doubt it.
The whole point of protected ranges is that only you have edit rights, so being able to edit the script would be unlikely.