View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

maybe you could relocate the validation list to another part of the
worksheet or to another worksheet. Yes you can by giving it a name and
=mylist

--
Don Guillett
SalesAid Software

"Steve" wrote in message
...
I created a couple validation lists on my worksheet and when I try to sort
the data in the worksheet, the validation data gets sorted, too, so the
drop-down lists refer to cells that have different data than prior to the
sort. I want to set up the worksheet to that I can protect the lists from
sorting with the rest of the worksheet. Is this possible?