|
Sub shtname()
Dim i As Integer, sht As Worksheet
i = 1
For Each sht In Worksheets
Sheet1.Hyperlinks.Add Cells(i, 1), "", sht.Name & "!A1", , sht.Name
'在Cells(i,1)单元格添加超链接,超链接至sht工作表的A1单元格,超链接名为工作表名
i = i + 1
Next
End Sub
如果工作表中名字中出现空格 索引无效。 请各位牛人 帮忙再修改下
- Sub shtname()
- Dim i As Integer, sht As Worksheet
- i = 1
- For Each sht In Worksheets
- Sheet1.Hyperlinks.Add Cells(i, 1), "", "'" & sht.Name & "'!A1", , sht.Name '工作表名两边加英文单引号试试
- '在Cells(i,1)单元格添加超链接,超链接至sht工作表的A1单元格,超链接名为工作表名
- i = i + 1
- Next
- End Sub
复制代码
|
|