View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default Lock cells for combo box values only

Hi,

I created an excel file where some of the cells are using "Validation" rules
that when the user selects the cell he can open a combobox that shows values
from a range declared earlier.

I want to limit the user to select only values from the list - currently he
can select from the list and write something else.

Also - how can I turn AutoComplete on these cells as well ?

Thanks,