Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 02 June 2022
  0 Replies
  894 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.