Which will allow sorting only on a contiguous range of unlocked cells.

Say A1:F30 are unlocked, you could sort that range.

If even one cell within that range was locked, sort would not be possible.


Gord Dibben MS Excel MVP


On Sat, 6 Sep 2008 03:25:01 -0700, StpNs
wrote:

Try this:

Click Tools Protection Protect Sheet Select sort within Allow all
users of this workbook to: