Hyperlink question

  • Thread starter Thread starter xnman
  • Start date Start date
X

xnman

Is there a way to set a hyperlink in a cell of workbook1 pointing to a
specific cell in workbook2 so that when you click on the cell you see what
is in the specific cell in workbook2?
 
Yes, but you will be in workbook2, not just see what is in the cell.

Do insert=>Hyperlink,
in the dialog, in the top box, hit browse and select you workbook

Click in the bottom box and click browse, then select sheet and reference
(cell address)

for example (from the immediate window)

? activecell.Hyperlinks(1).Address
C:\Data\aa_dateposition.xls
? activeCell.hyperlinks(1).SubAddress
Sheet2!B9


Regards,
Tom Ogilvy
 
Back
Top