View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jbachaud jbachaud is offline
external usenet poster
 
Posts: 1
Default How to sort protected worksheet in Excel 07? Doesn't work.

I have built a protected worksheet with data that is in a sort table. I have
set the protection to allow auto filtering and sorting, and Excel displays
the ability to sort a-z or z-a, but selecting these functions does nothing.
It does allow me to filter based upon data in the columns, but not to sort.
If I unprotect the worksheet, everything works fine, but I can't leave it
unprotected for the end-users.
HELP!

Thanks in advance