conditional locking/unlocking of cells

  • Thread starter Thread starter Mparekh
  • Start date Start date
M

Mparekh

Is there a way to conditionally lock or unlock cells in a worksheet. Fo
e.g. If cell 1 in Col A has X value in that case lock Cell 1 of Col B o
else unlock it and so on and so forth. Would appreciate if someone ca
show me how to do this using a formula and not a macro.



Thanks in advance.
Parek
 
Formulas in cells can only return or calculate values.
They cannot alter cells in a worksheet. VBA is needed.

HTH
Jason
Atlanta, GA
 
Back
Top