Macro that sorts sheet tabs alphabetically.

[robcgp1200]

Hello,
I am new to the forum, and have limited programming experience. I have created a training matrix that creates additional worksheet tabs titled by individual names. I am looking for help in writing a macro that can sort these sheet tabs alphabetically. I have two sheet tabs that i would like to remain constant, ex. sheet1, sheet2, but all remaining sheets would need to be alphabetical.
Thank you for any help.

[sktneer]

You may try something like this....

Please Login or Register  to view this content.

The above code will skip the sheets Matrix and Data and sort all other sheet if any in the workbook in ascending order.

[robcgp1200]

Thank you, that works great. I really appreciate your help. If I have additional questions regarding this same spreadsheet should I start a new thread or ask it now?

Thank you, Robert

[sktneer]

You're welcome Robert! Glad it worked.
Please open a new thread with your new question.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.