V
V
Vitos1994_12020-06-19 11:51:16
Google Sheets
Vitos1994_1, 2020-06-19 11:51:16

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

2 answer(s)
G
Grigory Boev, 2020-06-19
@ProgrammerForever

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.

A
Alexander Ivanov, 2020-06-19
@oshliaer

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 question

Ask a Question

731 491 924 answers to any question