Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |