Sorting in a protected cell (Excel 2007)

G

Geoff

I have a table with autofilter on a protected sheet. When I protected the
sheet, I have allowed users to sorting and use autofilter. The autofilter
works fine, but when I go to sort I get a message that I need to unprotect
the sheet.

What am I missing here. What functionality is allowed when I allow sorting
when protecting if I cannot sort the table?
 

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

Sorting whole Protected 2003 REDUX 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting while protected - this question may not have been covered. 1
Dealing with the error: unable to filter on excel hc home school 0
Using "sort" in auto filter not possible when protected? 0
Worksheet Protection & Sorting 0
Utilizng full AutoFilter features while specific cells are protect 0
Sorting Multiple Tables 1

Top