View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default allowing sort in protected worksheet

You have 2 choices:
1) Unprotect the sheet then change the Security for those 4 columns (via
Format -- Cells -- [Protection] and clearing the "Locked" box for them.
Then put your sheet back into protection mode with the option to permit
sorting still selected.

2) Use a VBA solution that would unprotect the sheet, perform the sort, put
the sheet back into protected mode.


"rohit" wrote:

I have a protected ws. How can allow a table with 4 columns to be sorted
alphabetically w/o unprotecting the ws?