Protect Data, but allow sorting
Hi,
I have had similar instances, and have got round it by writing a macro to do
the sort, and making themacro available on a menu/button or control key
sequence.
HRman
"Pete Walburn" wrote:
Hello,
In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?
In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.
Pete
|