If you are using a list then that should be enough unless they copy and
paste into the validation cell


--

Regards,

Peo Sjoblom

"smf" <smf@discussions.microsoft.com> wrote in message
news:448D4166-A2C9-4C25-852F-7B045DF19F98@microsoft.com...
> Hi,
>
> I have an xls that I have set up with validation lists in some cells. I
need
> to stop users from ignoring the options in the list and just typing
whatever
> the want in the cell.
>
> Anyone help? I am sure it is easy, but can't see how to do it.
>
> Thnx,
>
> Smf