| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
allowing sort in protected worksheet
I have a protected ws. How can allow a table with 4 columns to be sorted
alphabetically w/o unprotecting the ws? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
allowing sort in protected worksheet
You have 2 choices:
1) Unprotect the sheet then change the Security for those 4 columns (via Format -- Cells -- [Protection] and clearing the "Locked" box for them. Then put your sheet back into protection mode with the option to permit sorting still selected. 2) Use a VBA solution that would unprotect the sheet, perform the sort, put the sheet back into protected mode. "rohit" wrote: I have a protected ws. How can allow a table with 4 columns to be sorted alphabetically w/o unprotecting the ws? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing users to use filters and sort on protected pivot table | Excel Discussion (Misc queries) | |||
| Allowing users to use filters and sort on protected pivot table | Excel Discussion (Misc queries) | |||
| Allowing sort of protected cells | Excel Worksheet Functions | |||
| Allowing insert pictures in a protected worksheet | Excel Discussion (Misc queries) | |||
| How to Sort Protected Worksheet | Excel Worksheet Functions | |||
Linear Mode
