Hyperlink won't work...help please
 

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.

Hyperlink won't work...help please
 

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"

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

NikkoW wrote:
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.