#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default worksheet tabs

Hi

In the 2003 excel-- Is there a way to have the worksheet tabs automatically
go in alphabetical order-- or do you have to do in manually?
--
Thank-you!
Ruth
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default worksheet tabs

Ruth,

Use this code:

Sub ArrangeSheetsInOrder()
Dim iCount As Integer
Application.ScreenUpdating = False
iCount = Sheets.Count
For i = 1 To iCount - 1
For j = i + 1 To iCount
If Sheets(j).Name < Sheets(i).Name Then
Sheets(j).Move Befo=Sheets(i)
End If
Next j
Next i
End Sub



"Ruth" wrote:

Hi

In the 2003 excel-- Is there a way to have the worksheet tabs automatically
go in alphabetical order-- or do you have to do in manually?
--
Thank-you!
Ruth

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default worksheet tabs

You can do it with code. See www.cpearson.com/excel/sortws.aspx

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Wed, 6 Jan 2010 07:08:01 -0800, Ruth
wrote:

Hi

In the 2003 excel-- Is there a way to have the worksheet tabs automatically
go in alphabetical order-- or do you have to do in manually?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to name worksheet tabs using a cell within the worksheet? Jennifer Excel Discussion (Misc queries) 4 November 6th 12 06:03 PM
Worksheet Tabs Cheri Excel Discussion (Misc queries) 1 April 14th 08 11:54 PM
Worksheet tabs Mike D. Excel Discussion (Misc queries) 6 January 20th 07 03:11 AM
Can Excel worksheet tabs be relocated above the worksheet? BCWB Excel Discussion (Misc queries) 1 November 1st 06 10:14 PM
Worksheet Tabs Me Excel Discussion (Misc queries) 5 December 7th 05 03:27 PM


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"