View Single Post
  #4   Report Post  
dominicb
 
Posts: n/a
Default


Good afternoon balzon

A couple of ways to do this. First of all, you can just drag the tabs
across the bottom to their new position doing it manually.
Alternatively Chip Pearson has a VBA routine at his site to rearrange
them in alphabetical or reverse alphabetical order. If you don’t fancy
getting involved with VBA I have a free add-in available to anyone who
requests it, that will allow you to arrange sheets alphabetically (and
reverse) or move sheets up and down in a list and arrange them that
way.

Chip Pearsons site is here (http://www.cpearson.com/excel/sortws.htm),
if you want my add-in, just e-mail me.

HTH

DominicB
)


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=469882