Re: Data Sort with Protected Worksheet
try the following steps:
before you set the protection, turn on the autofilter for the designated columns. (of course first you should set the locked/unlocked cells)
then got to protection and check the followings:
select locked cells (delete the check mark)
select unlocked cells
and be sure that the others are unchecked.
After protecting you'll be able to do only those commands, what you've need.
Hope it helps.
see attached small sample workbook.
the passwoer to unprotect is "a"