PDA

View Full Version : [SOLVED] Can I Hypelink to a specific worksheet in another workbook?



kane
06-30-2005, 01:56 PM
Hello,

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

Is this possible?

:think:

Justinlabenne
06-30-2005, 08:45 PM
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
06-30-2005, 08:57 PM
Great Work, Justin!

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

Thx.

kane
07-01-2005, 10:42 AM
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
07-01-2005, 11:10 AM
You mean like this?

MOS MASTER
07-01-2005, 11:15 AM
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, :yes

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! :whistle:

MOS MASTER
07-01-2005, 11:17 AM
You mean like this?
Sorry justin we where typing simultaniously! :rofl: :rotlaugh:

kane
07-01-2005, 12:03 PM
Haha, perfect. Thanks so much for you time.

MOS MASTER
07-01-2005, 12:14 PM
Haha, perfect. Thanks so much for you time.
Glad J & J could help! :yes