conditional locking/unlocking of cells

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 
Top