View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLM CLM is offline
external usenet poster
 
Posts: 12
Default how to sort in a protected worksheet.

i have a large worksheet with over 500 rows and 50 columns that needs to be
sent out to a large audience. how can I allow the worksheet to be sorted
while it is protected? i have tried protecting only certain columns of data
and tried to sort, but it only allows me to sort only the columns that are
not protected and the data in each row entry isn't "expanded" the sort.
--
/clm