当前位置: 代码迷 >> 综合 >> 在excel中自动加载索引页
  详细解决方案

在excel中自动加载索引页

热度:14   发布时间:2024-01-16 09:03:59.0

Sub Macro2()
'
' Macro2 Macro
'

On Error Resume Next
       Worksheets.Add().Name = "index"
Sheets("index").Select
'显示所有工作表
For i = 1 To Sheets.Count
Cells(i, 1).Value = Sheets(i).Name
Next
'超链接
For i = 1 To Sheets.Count
    t = Cells(i, 1)
    Cells(i, 1).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=t & "!A1", ScreenTip:="进入", TextToDisplay:=t
Next

End Sub

  相关解决方案