View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
albie60 albie60 is offline
external usenet poster
 
Posts: 1
Default Allowing sort of protected cells

I have data within certain cells I want to protect but I also want to allow
sorting of those same cells. In other words, I want to allow users to sort
ALL cells (protected and unprotected) but restrict them from changing the
values of of the protected cells. I can't seem to find an answer.