View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Worksheet Sort Order

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