I have the permissions set under protection to allow sorting; but, But, users get this message "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password."
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is there a way to be able to sort in a shared worksheet/workbook that is password-protected?
- Thread starter PattiK323
- Start date
mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,355
Allow Sorting allows the user to sort unlocked cells, locked cells still cannot be moved.
It sound like your users are sorting a range that includes both locked and unlocked cells. Perhaps whole rows.
To sort while a sheet is protected all the cells in the sort must be un-locked AND the allow sorting option must be set.
It sound like your users are sorting a range that includes both locked and unlocked cells. Perhaps whole rows.
To sort while a sheet is protected all the cells in the sort must be un-locked AND the allow sorting option must be set.
Upvote
0
