79 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
205
views
Excel adding rows in a table when sheet is protected
I want to be alble to add rows to a table in protected sheet but I cannot get it to work.
In have named table (range) of which all the cells of that table are unlocked. (Selected the whole table, ...
-1
votes
1
answer
159
views
TypeError: protection.remove is not a function
I am trying to lock a sheet when my script begins to run and unlock it when the script is finished. I have pulled the sample code from the documentation but am running into an error. My current code ...
0
votes
0
answers
23
views
select unlocked cell and selecrt locked cell is not working on the sheetprotection in openXML, C#
I am trying to protect an excel sheet where the cells can be selected but not editable I have made the cells unlocked in the cell format but the selection is disabled once the Excel file is opened.
...
0
votes
0
answers
88
views
Google apps script to limit access on edit so that only the owner and the one who edited the cell have access
I tried to make a script that on every edit, if the cell is empty everyone has access to edit it. If someone edits it, only that person and the owner can edit it. I have to mention that every user is ...
0
votes
1
answer
110
views
How to set protections on sheet sections both on startup and on cell after user edit
So I am trying to set up a google sheet that dozens of users are going to use and I want to automate the protection schemes since a new sheet is being made everyday. I'm trying to have sheet headers ...
0
votes
1
answer
148
views
Google App Scripts work 100% for me, but no one else
I have written a simple spreadsheet to record archive entries for an historical society. First tab is a data entry form where the user inputs each record’s detail. The other tabs simply display all ...
1
vote
1
answer
145
views
Split sheet into multiple workbooks, keeping formatting and sheet protection/locked cells
I have working code in a module to split data in a worksheet tab into over 50 new worksheets based on the value in column A.
I need to also
(1) copy the sheet protection/locked cells
(2) copy the ...
1
vote
1
answer
65
views
Script to Unprotect All Protected Ranges
I wrote an Apps Script file to protect cells on-edit, and it was working for a while, but it stopped working recently. I suspect I hit some sort of cap on the number of protected ranges one sheet can ...
-2
votes
1
answer
68
views
Is there a way to limit what causes an installable trigger to run?
Is it possible to add nuance to an installable trigger? I have a function that is linked to an installable trigger (onEdit). The purpose of this script is to remove editors of cells with certain color ...
-2
votes
1
answer
117
views
How to apply protected ranges to all users in google sheets?
I have a code that that is doing what I want but I have one problem with it.
Basically below code is creating a protected range when the cell in AC Column is not empty and removing it when empty. Code ...
-1
votes
1
answer
69
views
Google Apps Script Protected Sheet Edit Permissions [closed]
I have developed a google sheet apps script based data collection tool. To give a simplified context, I have a modal form for lets say user registration where users who are given edit access to the ...
0
votes
2
answers
79
views
Allow user with edit privileges to run scripts on a spreadsheet owned by me
I have eight scripts with assigned buttons that work for me when accessing a spreadsheet. I would like to allow another user to run all of the scripts when clicking the associated button.
I ...
1
vote
1
answer
92
views
Google Sheet different cell ranges protection and access levels (all, specific, email-based)
Have this Google Sheet:
SourceSheet (sample data) is available: SourceSheet
Trying to implement protection rules:
The ranges B2:B10 and B13:B21 can be edited by everyone.
Ranges D2:D10 and F2:F10 ...
0
votes
1
answer
87
views
Protecting sheet. Selective editing permissions in Google Sheet
I have a table like this:
SourceSheet (sample data) is available: SourceSheet
I need to protect all cells but certain ranges can be edited by everyone and some ranges can be edited by only users ...
0
votes
1
answer
58
views
Is there any way to use apps script to add an exception to a sheet protection?
I'm making this city thing in google sheets, and I want to be able to add an exception to a sheet protection(see what I mean here). Is there any way to do this programmatically with apps script?
I ...