Can I Hypelink to a specific worksheet in another workbook?

[kane]

Hello,

I'm trying to hyperlink from workbook1.xls to worksheet 2 of 5 in workbook2.xls.

Is this possible?

[Justinlabenne]

Yes


Right click in a cell, Hyperlink. Try going through the browsed files, etc.. maybe open the book you will be opening to add it to the list of recently opened,

[sheeeng]

Great Work, Justin!

Just a suggestions,
Can it browse for a Excel file?

Thx.

[kane]

Thanks for your reply.

However I need the hyperlink to always goto cell A15 on worksheet 2.

The hyperlink only opens the workbook to where it was previously saved.

Thanks for you help though.

[Justinlabenne]

You mean like this?

[MOS MASTER]

Thanks for your reply.

However I need the hyperlink to always goto cell A15 on worksheet 2.

The hyperlink only opens the workbook to where it was previously saved.

Thanks for you help though.

Hi,

Insert the hyperlink like:

C:\Documents and Settings\Book1.xls#'sheet2'!a15

So after the path type: # and put the sheet name between Quotes: 'sheet1'
Then a: ! and the cell to jump to like: !a15

Enjoy!

[MOS MASTER]

You mean like this?

Sorry justin we where typing simultaniously!

[kane]

Haha, perfect. Thanks so much for you time.

[MOS MASTER]

Haha, perfect. Thanks so much for you time.

Glad J & J could help!