is there anyway in an excel macro to reorder the sheet tabs from left to right?
 

is there anyway in an excel macro to reorder the sheet tabs from left to
right?

Daniel

Presumably you mean alphabetically left to right?

Check out John Walkenbach site. He has a code for this. I think it is under
'bubble sort worksheets'

Alex

"Daniel" wrote:

is there anyway in an excel macro to reorder the sheet tabs from left to
right?

Try this, Daniel (is that you again?):
http://www.vbaexpress.com/kb/getarticle.php?kb_id=72
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Daniel" wrote in message
...
is there anyway in an excel macro to reorder the sheet tabs from left to
right?