View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smf
 
Posts: n/a
Default Stopping free text entry in validation cell

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