Solved: how to protect/unprotect column depending on cell value?

[henryadam]

Hi all,

i'm trying create macro to solve data entry
this problem is how to protect cell when status is "b"
if status "s" cell must be filled..

thanks all,

Henry

[lucas]

Could you clarify your need please? Are you saying that when a b is in one cell that another cell must be filled?

[henryadam]

condition:
IF col A="B" then col B protect else Col B unprotect.



Could you clarify your need please? Are you saying that when a b is in one cell that another cell must be filled?

[Simon Lloyd]

You can only protect a single column if that is the only column that has the cells locked all others would need to be unlocked.

You say "If Col A= "B" does the whole of column A have to be "B" or just a specified range or just any cell in the column?, would you want the whole of column B protecting or just a specified range or a single cell?