Hyperlink won't work...help please

N

NikkoW

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.
 
D

Dick Kusleika

Nikko

The Address will be the workbook name, not braces. The SubAddress will be
the location in the workbook.

Worksheets("Sheet1").Hyperlinks.Add Anchor:=LinkLoc, _
Address:="MacroHolder.xls", _
SubAddress:="Sheet1!A13". _
ScreenTip:="Link to detail", _
TextToDisplay:="Placeholder"
 
Top