excel 2007 - how do I sort workspaces in alphabetical order

Please upload an example workbook, so the experts can more readily assist.  Ensure its non-sensitive data, obfuscate the data if you need to.  There should be a framework from which to develop a solution, as your question is too broad.

Cheers,

Dave

I think iv over confused things. All I need are the sheets at the bottom of the page in alphabetical order. The picture above is in the order sheet1,sheet2 and Asheet3 which should be first. Hope that clears things up

Try this code depending on how you reply Yes will sort ascending no will sort descending all sheets in the workbook based on hte sheet name.
rgds/gowflow

Sub Sort_Active_Book()
Dim I As Integer
Dim J As Integer
Dim iAnswer As VbMsgBoxResult
'
' Prompt the user as which direction they wish to
' sort the worksheets.
'
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For I = 1 To Sheets.count
      For J = 1 To Sheets.count - 1
'
' If the answer is Yes, then sort in ascending order.
'
         If iAnswer = vbYes Then
            If UCase$(Sheets(J).Name) > UCase$(Sheets(J + 1).Name) Then
               Sheets(J).Move After:=Sheets(J + 1)
            End If
'
' If the answer is No, then sort in descending order.
'
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(J).Name) < UCase$(Sheets(J + 1).Name) Then
               Sheets(J).Move After:=Sheets(J + 1)
            End If
         End If
      Next J
   Next I
End Sub

Select allOpen in new window

For your easy refrence here is a workbook with the button in sheet1 and the code above that give you an example on how to implement in your workbook.
gowflow
Sort-Sheets.xls

Sorry but im confused as to how to use this code on my spreadsheet? Please advise.

ok fine
Are you using Excel 2007 or Excel 2003 ? as it is diffrent for each
gowflow

excel 2007