Auto sort with locked worksheets

Hi All,

I know there many posts about this topic already, but I also know nothing about VBA code. I was able to "Frankenstein" my sort code from posts I had found online, but I'd like to be able to now lock my worksheets but still run this code. There is only one worksheet that is sorting, so that should be the only worksheet that will need to be unlocked and re-locked. There are a few unlocked cells, and I would like the entire sheet to unlock, sort, then re-lock after data is entered in one of those cells. Here is the code that I have. I'm hoping that my request is a simple one and I apologize for my ignorance.

Please Login or Register  to view this content.

Thanks!

When locking the sheet, you could just tick off set sort box, this will allow the user to sort, while the sheet is locked? this could be easier

I thought maybe I should add some more background about my workbook. The unlocked cells are for results and when those results are entered the data changes in the four tables. The tables pull data from other locked worksheets where I haven't checked the sort box, but no data is sorted on those worksheets.

If theres no code on the protected sheet, you should just be able to add the following to your code:

Please Login or Register  to view this content.

Yes.. Subscript out of range is simply that "test" is not a sheets in your workbook

Please Login or Register  to view this content.

Thanks! And after a quick search online I was able to add code for the password so that wouldn't need to be entered.

Please Login or Register  to view this content.

Now I just need to find how to mark this "solved" .