Get Sheet Names - Remove Sort from this code

Hi, I would get rid of the entire ActiveX etc and just do it this way

Please Login or Register  to view this content.

The code you have just attached works fine here so I don't get the issue.
Yes, the only thing is the sorting which remains.
The code I posted without the ActiveX works fine too except that I added the enable events False to avoid macro's from being executed

Please Login or Register  to view this content.

The code I posted works with any Excel file that will permit macros.
If you say it doesn't work, WHAT doesn't work? Be a little more specific

Here are two files with the same code, one xlsm and one xlsb

I don't want to come across as be-learning but when you already have vba code and use it, I would at least expect some basic idea of how VBA works.
I would suggest you play along with the code and test, trial and error, that's the way it works and a lot of patience and time.
For now this is what you have to do

Modify this section of the code (my version) insert the row marked in red

Please Login or Register  to view this content.

Place any text you want instead of Hello but it's to give you the idea.
Since the entire column is cleared of contents you have to re-insert a value to be used as header, so you can do that on any row

I never got the change for taking any courses in VBA, just practice and lots of time.
I was lucky that my job permitted this and I just went for it.
Some links, not all really tried out but some things I did pick up there
https://excelvbaisfun.com/#Intro
And the next one is really great
http://www.cpearson.com/Excel/Topic.aspx

You can also check out Ron de Bruin, good one too
Happy coding