| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with sorting and Worksheet protect
Eileen
You can sort only on unlocked cells in a protected worksheet. e.g. Unlock cells A1:C10 then protect the sheet. Select A1:C10 and DataSort Gord Dibben MS Excel MVP On Tue, 23 Jan 2007 08:33:01 -0800, Eileen wrote: I'm clicking on the option to allow sorting by all users and then protecting the worksheet but when I protect the worksheet and then try to sort, I'm getting a message that I can't sort without unprotecting the worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
| Trouble sorting linked worksheet - need help | Excel Discussion (Misc queries) | |||
| Sorting Protected Worksheet | Excel Discussion (Misc queries) | |||
| Question about sorting in protected worksheet | Excel Worksheet Functions | |||
Threaded Mode
