Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Protection & Sorting
I have protected my worksheet, but allow users to: Select Unlocked Cells,
Sort, Use AutoFilter, and Use Pivot Table Reports. But when I enable the protection, the following error comes up when I go to Data,Sort: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protections submenu). You may be prompted for a password." It is important that all users be able to re-sort our data. What other task do I need to allow so this can happen? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Protection, Allow Sorting | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
sorting and protection | Excel Discussion (Misc queries) | |||
Protection and sorting | Excel Worksheet Functions |