How to lock a cell or a range (protect from accidental deleting or changing) from an author? I've tried a workaround to set my second account as an owner. But it is not convenient because all user-to-author requests goes there.

Also I can make somewhere a hidden copy of the cell and setup data validation. But this not looks very good, too. Because of 1) need to find secure place for this secret copy (probably I'll try directly in validation formula), and 2) this doesn't protect from deletion.

I figure out later:

I switch an owner to my second account, locked cell and then switch an owner back. And the cell remained locked for the main owner. So this state is possible! But the way described is really complicated.

CodePudding user response：

Use the Show warning when editing this range option.