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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
conditional formatting from a list 2
Lookup/index/match function 1
Comparing the values in two cells, then counting how many differ 2
conditional format of entire row based on a single cell in row 7
Filling empty cell with value from the cell above 2
Excel VBA 1
LookUP function with multiple variables and worksheets 1

Top