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
 
You must log in or register to reply here.

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

protect cell format 1
Protected Excel Worksheet 1
Confine Cell to Proper Case 2
"What-if" formula for either a manual entry and automated entry 3
Refreshing Pivot Table on a protected spreadsheet tab 1
protection and changing formulas 3
Lookup a particular cell in another excel workbook 1
Locking cells automatically after enter 2

Back
Top