Answer the question
In order to leave comments, you need to log in
How to organize access rights to certain sheets?
Good afternoon. I have a google spreadsheet with multiple sheets. How to organize access rights to certain sheets? That is, so that the employee has access only to a specific sheet.
Answer the question
In order to leave comments, you need to log in
It won't work separately. But if the " read-only " mode is suitable, then you can do this:
File - Publish to the Internet . Publish separate sheets for each user, and distribute individual links to data.
As you may have noticed, the access right is distributed to the entire Table.
Ranges can be protected inside the Table. And as a special case - the protection of sheets .
In this case, the user will still have access to the entire Table.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question