ExcelBanter - conditionally lock a cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditionally lock a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/191820-conditionally-lock-cell.html)

liketotrampoline

conditionally lock a cell?

I want to prevent editing in a cell, lock a cel based on a value in another
cell

I already have an if a1 = y then n/a but as an unlocked cell users keep
changing it.

All times are GMT +1. The time now is 10:17 PM.