View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danny J
 
Posts: n/a
Default sorting and protection

Hi folks,

Anyone know of a way I can prevent people selecting a whole column when they
sort? the problem is that when people do this the surnames become separated
from the first names. I realise this can be overcome by clicking in a cell
rather than selecting a column, so I wolud like to make selecting more than
1 cell for a sort impossible. To compound matters I cannot protect the
whole sheet as people need to put in info.

Help!

Many thanks,

Danny