Worksheet Sort Order

[donwb]

In Excel 2003, under VBA Explorer, VBA Project, Microsoft Excel Objects,
named Worksheets appear to be listed in their alphabetical order.
Can this be changed so they are listed:-
a) in their sheet number order and
b) in the order their named tabs are displayed in the workbook itself.
donwb

 

[Nigel]

They are listed in codename order, that is the name assigned in the VBIDE,
you cannot change the order.

 

[Chip Pearson]

If you really want to do it, you can change the CodeNames of the
worksheets. Select the sheet in the list, press F4 to display the
Properties window and change the Name property.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)