Questions tagged [google-sheets-protection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
0answers
33 views

How can I duplicate a Google sheets tab multiple times and retain the protections for each tab?

I found a great script from this community that allowed me to duplicate the tab while retaining the permissions, but I need to do this several times. For example, I need it to duplicate tab '1' 49 ...
1
vote
0answers
22 views

Google Sheets: How do I protect a sheet without locking its sheet name?

I have a Google Sheets workbook in which I need to protect all cells for data purposes. However, I need restricted users to be able to change the tab title of the individual sheets’ names. Does anyone ...
1
vote
0answers
20 views

How to give owner of copied Google Sheets doc same permissions as he has in the folder it's copied to?

We have a master form in Google Sheets that is copied by team members and shared with their clients to be filled in. We are using personal Google accounts associated with work emails, not G Suite ...
1
vote
2answers
27 views

How to prevent anonymous users from creating new rows

I have a Google sheet that I need to allow anonymous users to access. I have locked down all cells bar 3 that I want people to be able to edit. Unfortunately, people can still right click and create ...
9
votes
1answer
27k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
2
votes
1answer
3k views

Remove Protection from Range

I have created 50 spreadsheets for 50 students. Each spreadsheet contains 33 sheets, numbered 1 to 33, along with a couple of other sheets. Within each of these 33 sheets, there are many protected ...
11
votes
1answer
20k views

In Google Sheets how do I duplicate a sheet along with its permission

In a Google Spreadsheet called Attendance there is a sheet called Template. The user duplicates this sheet, renames the sheet with current date and uses this sheet to mark attendance for students. The ...