Automatic Cell Protection

Giganews Newsgroups
Subject: Automatic Cell Protection
Posted by:  Tom (tommcmillan20…
Date: Wed, 8 Oct 2003

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...