Worksheet Sort Order

D

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
 
N

Nigel

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[Q] How to sort tabs in order of CodeName 2
couple subs I need help with 1
Sort tabs numerically 9
VBA to sort list automatically in alphabetical order 6
Sort Worksheets 5
Insert new photo album - photos are in reverse order 0
Sorting Order for Worksheets 1
Using VBA to copy data into another worksheet ??? 2

Top