Reorder Sheet Numbers in the Project Window

[stuartgb100]

Hi,
I'm looking to change the order of sheets shown in the Project window.
For example, take two sheets:
#Genre - this shows as Sheet1(#Genre) in the Project window
&
#Worksheet Names Index - this shows as Sheet2(#Worksheet Names Index) in the Project Window

#Genre is the 1st entry in the Project window, but
#Worksheet Names Index is 12th entry

How do I make #Worksheet Names Index the 2nd entry, please ?

Thanks.

 

[Jeffrey Mahoney]

The VBA project shows the sheets in alphabetical order based on the "Code" name. Sheet2 comes after Sheet10, Sheet11, Sheet12, ... Sheet19. You can change the order if you edit the Code name. Show the Properties in the VBA project, click on Sheet2, and change the Name.

 

[stuartgb100]

Many thanks.
I understand better, and thanks for the example of "ASht(#Worksheet Names Index".

So, in your example
why is "ASht(#Worksheet Names Index" not listed AFTER Sheet20(Sheet20), please ?

Thanks.

 

[Jeffrey Mahoney]

A comes before S in the alphabet. It sorts by the code name. I wish I could use numbers as the first character in the code name, but no.

 

[stuartgb100]

Ooops !
Sorry, that wasn't the question that I meant to ask.
Should have been:
So, in your example
why is "Sheet2(#Worksheet Names Index" not listed AFTER Sheet20(Sheet20),

Thanks.

 

[Jeffrey Mahoney]

This has been this way since the DOS days. Sheet2 has less characters

 

[stuartgb100]

Many thanks again.
Regards.