I have a shared spreadsheet that can be edited by anyone who's got the link. Now I'd like to setup a protected range that can only edited by me, the owner.
Unfortunatly this is not working for me. I can not edit the permissions for the range in question, it just displays a Box similar to:
Visibility Options Save Cancel Ist this expected behavior? A bug? Not implemented yet?
tx for info
I figured out how to protect certain cell and allow anyone to edit other cells. It a workaround for now until Google improves this feature.
This finally worked for me. Hope it works for everyone else.
Carlton's answer worked for me, but after reading it I think I have a better understanding of the issue and a shorter workaround. It seems that the range protection value (view/edit) is taken from spreadsheet's general protection value at the time the range protection is defined.
Thus you could do with a simpler workaround:
Good luck.
user1958927's assessments seem to be correct - it kind of boils down to stripping it all to View Only for anonymous, then naming some ranges and protecting those. after opening it up to anonymous the named ranges stay protected.
furthermore, i found that any changes to the named ranges (remove a column, for example) will open that column for editing by anonymous.
handy catch and this makes google spreadsheets useful for large groups without craziness about logins to protect big chunks from inadvertent changes.
if you can deal with the gray diagonal lines all over the protected cells.
To clear the stripping grey lines, anyone can go to View and uncheck "protected ranges". It cleans the screen and the cells remain protected.
