Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort
Is there a way to lock a worksheet so that it can be sorted but not
mis-sorted similar to a database? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |