作者：乔山办公网日期：
返回目录：excel表格制作
h1.Submit()
Hyperlinks.Add anchor as Object, address as String, [subaddress], [sereentip], [texttodisplay]
anchor as Object 对象，，就是你要决定哪个单元格添加超链接的对百象
address as String 外部链接，网址，度是字专符串 ，用“”圈起来
[subaddress] 内部地址，子地址，也就是单元格地址，是字符串 ，用“”圈起来
[sereentip], 屏幕提示
[texttodisplay] 修改anchor as Object对象的内容信息
可以分别试一下
sub a()
sheet1.Hyperlinks.Add range("a1"),"具体加个网址比如baidu"
end sub
试下另一个
比如我想a1单元格跳转到属b2
sub a()
sheet1.Hyperlinks.Add range("a1"),""，"sheet1!b2"
end sub
Range("b4").Hyperlinks(1).Follow
修改成
With Worksheets(1)
.Hyperlinks.Add Range("E4"), "", "sheet2!F6"
End With