Automatic Cell Protection

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Is there a way to automaticly protect a given cell based
upon what is typed into another cell? (i.e. protect cell
A1 by typing "yes" into cell B1) A macro can do it, but I
would like to have it done automaticly. I've tried to use
an IF/THEN statment to trigger a macro but so far I have
been unsuccessful...
 
You could use Data Validation to protect what's in cell A1:

1. Select cell A1
2. Choose Data>Validation
3. From the Allow dropdown, choose Custom
4. In the formula box, type: =B1<>"Yes"
5. Click OK
 
Back
Top