Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 02 June 2022
  0 Replies
  554 Visits
0
Votes
Undo
Dear All,

I have read many posts on how to lock a range of cells based on a value on a specific cell, but none helped me.
I am having a spreadsheet where multiple users are filling in values in it.
I would like that if a value at the end of a row is filled (with any value) to lock the editing possibility to the rest of the cells in that row.
The solution should leave "editable" rows that do not have anything filled in the respective cell.
For example, in the row A1:O1, there are some values filled in (some cells might be empty).
When I am filling a value (any value) in cell P1 (the last cell in that row), the entire row should be blocked for any further editing.
Any other rows, if they do not have any value already filled in the cell P..., should be available for editing.

I have to add that I am not familiar with VBA.

Thanks in advance
There are no replies made for this post yet.
Be one of the first to reply to this post!