Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow sort of Protected Sheet
I have a wb with several hidden sheets and hidden columns of the unhidden
sheets (When in UserView). Although I turn on the "Sort" feature in the Protection options the user still cannot sort the worksheet. What do I need to do to keep the security but allow sorting? -- --- TraciAnn Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow sort of Protected Sheet
Make sure that all the cells in the range to sort are unlocked.
Then select the range to sort, then sort. "TraciAnn via OfficeKB.com" wrote: I have a wb with several hidden sheets and hidden columns of the unhidden sheets (When in UserView). Although I turn on the "Sort" feature in the Protection options the user still cannot sort the worksheet. What do I need to do to keep the security but allow sorting? -- --- TraciAnn Message posted via http://www.officekb.com -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow sort of Protected Sheet
You need to have all of the cells that are used in the sort 'unlocked' via
the Format Cells [Protection] tab. Then when they perform the sort they must only select those unlocked cells as they begin the sort operation. If you don't know how far down the sheet the range may extend and they may simply select columns and then go to Data -- Sort, then the entire columns must be unlocked. "TraciAnn via OfficeKB.com" wrote: I have a wb with several hidden sheets and hidden columns of the unhidden sheets (When in UserView). Although I turn on the "Sort" feature in the Protection options the user still cannot sort the worksheet. What do I need to do to keep the security but allow sorting? -- --- TraciAnn Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to - sort a protected sheet? | Excel Worksheet Functions | |||
Sort Protected Sheet | Excel Discussion (Misc queries) | |||
How to enable the sort function for a protected sheet | Excel Discussion (Misc queries) | |||
can i sort a protected sheet | Excel Discussion (Misc queries) | |||
Sort on a protected sheet | Excel Worksheet Functions |