View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J9 J9 is offline
external usenet poster
 
Posts: 7
Default Protect worksheet and still allow user to sort data

I need to protect a worksheet and still have the user be able to sort data by
column. I have tried using the "Unlock" feature in the Format
Cells--Protection dialog box but it doesn't make a difference. Once you
protect, you can't sort. Ideas?