| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allowing sort of protected cells
I have data within certain cells I want to protect but I also want to allow
sorting of those same cells. In other words, I want to allow users to sort ALL cells (protected and unprotected) but restrict them from changing the values of of the protected cells. I can't seem to find an answer. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allowing sort of protected cells
Maybe you could provide a macro that unprotects the sheet, sorts the data,
reprotects the sheet. albie60 wrote: I have data within certain cells I want to protect but I also want to allow sorting of those same cells. In other words, I want to allow users to sort ALL cells (protected and unprotected) but restrict them from changing the values of of the protected cells. I can't seem to find an answer. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing editing locked cells in a protected sheet in excel | Excel Worksheet Functions | |||
| Allowing comments in unlocked cells within protected sheet | Excel Discussion (Misc queries) | |||
| Allowing data entry in protected sheets | Excel Discussion (Misc queries) | |||
| Allowing hyperlinks an a protected sheet | Excel Discussion (Misc queries) | |||
| How do I sort protected cells? | Excel Discussion (Misc queries) | |||
Linear Mode
