Google sheets script to lock/protect rows based on value on another cell


I have a expense report table that employees put their expenses. Employees have a full write permission to Column A,B,C,D,E,F and managers have full permission to the table.

I need a script that once a manager put "approved" status on column H, the corresponding rows on column A,B,C,D,E,F should be locked for editing. In order to edit the approved cells, manager needs to change the "approved" status.

You can see the sample sheet here:

[login to view URL]

Can anybody help me on this?

Note: The freelancer should install the working script on the sample sheet that I have provided to get final approval.

Thanks in advance,

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel, Google App Engine, Scripting

Zobacz więcej: conditional locking of cells in google sheets, google sheets conditional protection, google sheets lock formatting, google script lock cells, auto-lock-cells-after-data-entry google sheets, google sheets lock conditional formatting, google script protect range, lock a cell once data is entered google sheets, \ google sheets\ script, \ google sheets script\ , i am looking for someone to write a google apps script in google sheets, google apps script for sheets, script update cell google sheets, add row excel based value, excel add row based cell value, excel script lock sheets, publish google calendar script, google adwords script, google translate script, google blogsearch script

O pracodawcy:
( 10 ocen ) Istanbul, Turkey

Numer ID Projektu: #17086709

Przyznany użytkownikowi:


This is the code for your work sheet Private Sub Worksheet_Change(ByVal Target As Range) If [login to view URL](2, 7).Text = ""X"" Then [login to view URL](Cells(3, 7), Cells(66, 7)).Locked = True Else ActiveShe Więcej

$25 USD w 1 dzień
(0 ocen)

9 freelancerów złożyło ofertę na kwotę $30 do tego projektu


Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Więcej

$25 USD w ciągu 1 dnia
(100 Oceny)

Hello, I went thru the project description. This can be done by today Kindly check my past projects and reviews Today can start. Looking forward to hearing from you Thanks Regards Thushara

$30 USD w ciągu 1 dnia
(18 Oceny)

What is the deadline for this job? And am available to work on your project Data entry am conversant

$30 USD w ciągu 1 dnia
(0 Oceny)
$35 USD w ciągu 1 dnia
(0 Oceny)

I am an Accountant.I am looking for a position that would recognize my talent and provide me an opportunity to put in my best for the benefit of the [login to view URL] my work experience I have versatile Expertise working on m Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)

hi this is vidya i have 3 years experience in quallity analyst ill give 100% qualityas soon as possible thanks & regards

$40 USD w ciągu 1 dnia
(0 Oceny)

Dear Client, Today I have found this job post on Freelancer, and I'm interested in your job Post involving the need of a data entry assistant I have good experience In data entry, web research, Image Conversion and Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)
$34 USD w ciągu 1 dnia
(1 Ocena)