View Full Version : [SOLVED:] Can I Hypelink to a specific worksheet in another workbook?
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.
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:
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.