Eileen

You can sort only on unlocked cells in a protected worksheet.

e.g. Unlock cells A1:C10 then protect the sheet.

Select A1:C10 and DataSort


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 08:33:01 -0800, Eileen
wrote:

I'm clicking on the option to allow sorting by all users and then protecting
the worksheet but when I protect the worksheet and then try to sort, I'm
getting a message that I can't sort without unprotecting the worksheet.