View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
esslingerdav esslingerdav is offline
external usenet poster
 
Posts: 2
Default sorting protected sheets

I have a worksheet that has a column of locked cells but all the rest are
unlocked. I want all the locked cells protected to keep multiple users from
messing up formulas. Is there a way to sort this sheet after it is
protected? I am having to unprotect the sheet everytime I want to resort the
data. thanks!