Hi mac

To use code...
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True,
AllowSorting:=True

To protect manually...
"ToolsProtectionProtect Sheet" and select "Sort"and any other options you
want from the dialog box..

But what version of XL are you using?
--

XL2003
Regards

William



"mac" wrote in message
...
Hello,
I was wondering if there is a way to protect a sheet, but be able to sort
the data? Does anyone know a way around this. Any help is appreciated.
--
thank you mac