Sub mulu()

On Error GoTo Tuichu

Dim i As Integer

Dim ShtCount As Integer

Dim SelectionCell As Range

ShtCount = Worksheets.Count

If ShtCount =  Or ShtCount =  Then Exit Sub

Application.ScreenUpdating = False

For i =  To ShtCount

If Sheets(i).Name = "目录" Then

Sheets("目录").Move Before:=Sheets()

End If

Next i

If Sheets().Name <> "目录" Then

ShtCount = ShtCount +

Sheets().Select

Sheets.Add

Sheets().Name = "目录"

End If

Sheets("目录").Select

Columns("B:B").Delete Shift:=xlToLeft

Application.StatusBar = "正在生成目录…………请等待！"

For i =  To ShtCount

ActiveSheet.Hyperlinks.Add Anchor:=Worksheets("目录").Cells(i, ), Address:="", SubAddress:= _

Sheets(i).Name & "!R1C1", TextToDisplay:=Sheets(i).Name

Next

Sheets("目录").Select

Columns("B:B").AutoFit

Cells(, ) = "目录"

Set SelectionCell = Worksheets("目录").Range("B1")

With SelectionCell

.HorizontalAlignment = xlDistributed

.VerticalAlignment = xlCenter

.AddIndent = True

.Font.Bold = True

.Interior.ColorIndex =

End With

Application.StatusBar = False

Application.ScreenUpdating = True

Tuichu:

End Sub