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

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

--

Regards,
Nigel




"donwb" wrote in message
...
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

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)


On Fri, 20 Mar 2009 07:07:54 -0000, "Nigel"
wrote:

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