|
- Private Sub CommandButton1_Click()
- Dim i As Integer
- Dim x As Worksheet
- Sheets(1).Columns(1).ClearContents
- Set x = Sheets(1)
- x.Name = "目录"
- Debug.Print Worksheets.Count
- For i = 2 To Worksheets.Count
- With Worksheets(i)
- x.Cells(i, 1) = .Name
- .Hyperlinks.Add anchor:=x.Cells(i, 1), Address:="", SubAddress:="'" & .Name & "'!a1"
- ' .Hyperlinks.Add anchor:=Sheets(i).[h1], Address:="", SubAddress:="目录!a1", TextToDisplay:="返回"
- End With
- Next
- Sheets(1).Columns(1).Font.Underline = xlUnderlineStyleNone
- End Sub
复制代码 加了两句 |
评分
-
查看全部评分
|