Hyperlinks to '[workbook]Sheet!'Range(Cell)

[Snoopy]

Dear fellows

I'm struggling with my hyperlinks.
Do anyone know the hyperlink-code/reference to a specified sheet and
cellreference in another workbook?

I want my hyperlink to open this other workbook somwhere in my
filestructure, and activate a specified sheet/cell in this workbook.

Is it possible, and how?


I'll appreciate your kindly help

Regards
Nils Morten

 

[Laurent]

Hello,

try the following as hyperlink address:

C:\Users\me\Documents\test.xlsx#Sheet2!A4

It works with Excel 2007.

Laurent

 

[Snoopy]

Hello,

try the following as hyperlink address:

C:\Users\me\Documents\test.xlsx#Sheet2!A4

It works with Excel 2007.

Laurent











- Vis sitert tekst -

Thanks pal - i'll try it out