how to protet a cell
In order to do this you would need to validate the names because Excel has no
way of knowing if John Smith or sfnksdfk is a name.
To do this create a list of accpetable names and then select your input cell
and click data - validation - select list and then input the range of your
list (A1:A100 for example). users will then only be able to selct names from
the validated list.
Mike
"Scottyvan" wrote:
I would like to know if there is a way with excel 2003 to protect a cell and
the type the answer in that cell?
Example:
Name______________________ and to be able to type your name in the line.
|