Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can't figure out why this won't work.
Worksheets("sheet1").Hyperlinks.Add Anchor:=LinkLoc, _ Address:="[MacroHolder.xls]Sheet1!A13", _ ScreenTip:="Link to detail", _ TextToDisplay:="Placeholder" When I click on the hyperlink, an error dialog appears "Cannot open the specified file." The file is indeed called MacroHolder.xls and the destination is A13 on sheet 1. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why hyperlink does not work after been copied to another file? | Excel Worksheet Functions | |||
Hyperlink won't work | Excel Discussion (Misc queries) | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Hyperlink doesn't work - need a macro.... | Excel Programming | |||
Hyperlink Code will not work in XL2002 | Excel Programming |