sort
 

Is there a way to lock a worksheet so that it can be sorted but not
mis-sorted similar to a database?

You could protect the worksheet and provide a macro that unprotects the sheet,
sorts the data the way you want, and then protects the worksheet.

I don't think that there's a way to really stop people (like me) from screwing
up really badly.

Crohn wrote:

Is there a way to lock a worksheet so that it can be sorted but not
mis-sorted similar to a database?

--

Dave Peterson

I think you will have to state your question more explicitly.

Have you tried first selecting all cell before you do your sort.
Ctrl+A (or in Excel 2003 invoke that twice)

If you are referring to lock cells as in protection, you have to
turn the protection off first like in a macro.

If you are referring to protection, what version of Excel.
There are differences and I can't help you beyond 2000.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Crohn" wrote ...
Is there a way to lock a worksheet so that it can be sorted but not
mis-sorted similar to a database?