Sort sheets in a specific order

[Radikal9k]

Hello

I have a file with around 50 tabs that are in a certain order
When people use this file they make a copy of it and add all their inputs and unfortunately change the order of the tabs (I can't avoid that)

The problem is that when we want to review the file each version of it has a different order so it's a mess to find anything
I was wondering if there is a macro that would let me sort my tabs in a specific order?
Everything I find online is about sorting alphabetically but nothing else, and i can't change the names of these tabs (there are huge macro working in this file that use this names that i don't want to brake...)

Thanks

[cubangt]

Have you taken a look at using the sheet index to order them?
without a sample file to work with, can only offer suggestions, If the file was originally in a certain order and you know what each sheet index is, you can try to order them by index instead of sheet name.

https://www.thespreadsheetguru.com/t...heet-positions

Take a look at this example.

[dangelor]

Possibly...

Please Login or Register  to view this content.

Set rg to a list of sheets in the order you want.

[gijsmo]

Here's a generic macro using sheet names for sorting alphabetically

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Post deleted.

[kvsrinivasamurthy]

'Names' sheet is having list of sheets in required order. Code Sorts the sheets in the same order as in 'Names' sheet.
Code for macro

Please Login or Register  to view this content.

[Radikal9k]

Thanks all, i'll give it a try!

[Radikal9k]

Worked, thank you