Hyperlink won't work...help please

  • Thread starter Thread starter NikkoW
  • Start date Start date
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.
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add hyperlink using sheet names and cells(i,j) 3
Creating a hyperlink in Word from Excel 3
Re : Excel HyperLinks to WorkSheets & Chart-Sheets 4
Hyperlinks to other Sheets 4
Assigning a Hyperlink to A Cell that References a Worksheet 2
Workbook Cell as Target of Hyperlink Object 6
I have created a vba script for a document registers 7
Hyperlink 3

Back
Top