View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.