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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Snoopy - 21 Mar 2007 09:23 GMT

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

Reply to this Message

Laurent - 21 Mar 2007 11:17 GMT

Hello,

try the following as hyperlink address:

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

It works with Excel 2007.

Laurent

> Dear fellows
>
[quoted text clipped - 11 lines]
> Regards
> Nils Morten

Reply to this Message

Snoopy - 21 Mar 2007 12:06 GMT

> Hello,
>
[quoted text clipped - 23 lines]
>
> - Vis sitert tekst -

Thanks pal - i'll try it out

Reply to this Message