Hi George

If you use 2002 or 2003 then when you protect your sheet you check "Sort"
in the list. (ToolsProtection.....Protect sheet)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Tattam" wrote in message ...
I have a worksheet with a very simple macro which sorts a range of data on the last column in the range.The macro runs fine when
the worksheet is unprotected but fails when protected. The error message is "Sort method of range class failed". I have made sure
all the cells in the range are unlocked.I am running on Windows 2000.Any Ideas?