Worksheet Protection & Sorting

K

king60611

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Protected worksheet allow users 1
Utilizng full AutoFilter features while specific cells are protect 0
Sorting whole Protected 2003 REDUX 0
How to change format protection default to unlocked? 2
Sorting while protected - this question may not have been covered. 1
I overprotected my spreadsheet! Need help ASAP!! 2
Sorting in a protected cell (Excel 2007) 0

Top