Sub Ŀ¼Á´½Ó() '¹¤×÷±íÁ´½Ó Dim R%, i%, f As Object Application.ScreenUpdating = False On Error Resume Next If InStr(1, ActiveSheet.Name, "Ŀ¼") = 0 Then 'Èç¹ûµ±Ç°²»ÊÇĿ¼¹¤×÷±íÔòÔö¼Ó Sheets.Add ActiveSheet.Name = "Ŀ¼" Else Set f = Columns(1).Find("*") '¼ì²éAÁÐÊÇ·ñÓÐÊý¾Ý,ÈçÓÐÔòÔö¼ÓÒ»ÁÐ If Not f Is Nothing Then Columns(1).Insert End If End If For i = 1 To Sheets.Count R = R + 1 Cells(R, 1) = Sheets(i).Name ActiveSheet.Hyperlinks.Add Cells(R, 1), "#'" & Sheets(i).Name & "'!A1", ScreenTip:=Sheets(i).Name Next i Application.ScreenUpdating = True End Sub
[此贴子已经被作者于2008-12-29 10:14:37编辑过] |