Hyperlink question

[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?

 

[Tom Ogilvy]

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