"sheet" name assignment re-ordering

[omahaNative_1023]

please see my image. is there way to make sheets that appear in code editor show in order that i want? in my image, i circle 2 sheets that are always visible and are on left side of interface where sheets are listed at bottom of the screen. but what i want is for those circled and 3 more like it to appear at top of the list for lowest indexed because they are left-most on my workbook. is that possible? how excel assigns these numbers? and what happens with the numbers if i create sheets and then delete them. do the numbers get mixed up? because i think i did lot of that in this book. thank you

[Richard Buttrey]

Hi,

The VBE sheet code names appear in alphabetical order. You'd need to edit the sheet property code name and add an initial "a", "aa", "aaa"...etc to the existing names

Programatically you can change the code names with

Please Login or Register  to view this content.

You may need to change the Trust Centre Macro settings to allow access to the VBA Project Object model

[omahaNative_1023]

what you mean they appear in alpha order? they literally appear like this to me in the image

Please Login or Register  to view this content.

and i created them in this order

Please Login or Register  to view this content.

can i get them reordered based on what you said? really what i want is order of creation, even if i delete sheets in between creating new ones

Please Login or Register  to view this content.