Even though you select those options there are severe limitations and
conditions

Autofiltering.................only if Autofilter is enabled prior to
protecting the sheet

Sorting..............sort only a block of contiguous unlocked cells.

The only way around all the restrictions is have a macro which
Unprotects the sheet, does the sort or filter then Reprotects.



Gord

On Mon, 2 Jan 2012 21:05:26 -0800 (PST), wrote:

Is it possible to "Allow" Sorting and use of Autofilter with respect
to Locked cells when the worksheet is Protected?

Even though I have checked both 'Sort' and 'Use Autofilter' under the
"Allow all users of this worksheet to:" options list, when enabling
protection, I am not able to perform either operation when the target
cells are Locked.

If I set the cells to be sorted or filtered to be Unlocked then it
works just fine when the worksheet protection is enabled.

I have "read" that by selecting the appropriate "Allow users to ...."
option the desired functionality should work with respect to target
cells that are set to the Locked status - what do I need to do
differently?

Any guidance would be greaty appreciated.

Thanks!

John