Lock Cell based on another cell value

[swertel]

I have some conditions in my calculations that I want to make a bit more user friendly. I have conditional formatting set up to make the user choice visibly obvious, but I also want to conditionally lock cells based on values in other cells.

How would I go about doing that, if it is even possible?

--Scott

http://wertel.eng.pro

 

[brengine]

You could have an Event monitor macro running...i.e. in the API Sheet/WorkSheet/SelectionChange

Then use it to change the protection on a cell(s).

Ken

 

[swertel]

Thanks, I'll look into that.

--Scott

http://wertel.eng.pro