Hi,
I am trying to come up with process for an online Excel sheet which will lock access to a range if a cell is set to "Yes"
Please see below
Capture.JPG
I will be sharing this file so need the locking of the cells to happen automatically.
The conditional cells in column D, Yes/No are already on restricted access to prevent users from selecting.
Really stuck on this so would really appreciate any help here.
Thanks,
Bookmarks