Help w VBA Sorting Named Ranges

Hi

This would happen if the worksheet is protected. Is that the case?

I do have that particular worksheet protected. Thank you for that info! I didn't know you couldn't run a macro on a protected sheet. Is there a workaround to that?

Originally Posted by jlheath01

I do have that particular worksheet protected. Thank you for that info! I didn't know you couldn't run a macro on a protected sheet. Is there a workaround to that?

Well, you can

Unprotect
Sort
Protect

That sort of defeats the purpose of a protected worksheet

Originally Posted by jlheath01

That sort of defeats the purpose of a protected worksheet

Well, you cannot say at the same time
- I want the worksheet to remain unchanged
- I want to change the worksheet



If you want the worksheet to remain unchanged then you cannot sort. If you want to sort then unprotect, change and protect.

Notice that it does not defeat the purpose completely.
- The worksheet is protected and so the user will not change something by accident
- When you sort you (the author, not the user)are using vba and so we can say that you are doing it staying in control. The user can have for ex. a button to invoke the sort, but won't have access to the worksheet when it is unprotected

You just have to figure out what's the best course of action in your specific case.

I see what you're saying. In my mind, I was thinking the cells where the data & formulas are located could be protected, but a user could still sort. Thank you for all of your help.

I'm glad it helped. Thanks for the feedback.