• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

XL not allowing me to Sort locked cells..normal?

B

BigD

Member
When protecting the sheet, I click "Sort" hoping XL will let the user sort the file, but this is not the case.

I can highlight all the rows except the header, and it will sort. However, this does not sort the top row.

Anything that I can do different to make this work?
 
BigD: is your data source an Excel Table. If so, then I believe that's a bug with MS's implementation of Tables, and you'll have to either leave that region unprotected, or use some VBA to unprotect, sort, and reprotect. If not, you should be able to accomplish this by ticking the Sort checklist from the Protect Sheet dialog box.
 
You must log in or register to reply here.
Back
Top