Hyperlink to Specific Page of Another Workbook

[DeLaMartre]

I would like to be able to use a hyperlink to go to a specific worksheet of a completely separate workbook. Whereas it is easy to hyperlink to another workbook, I can't figure out how to go directly to the worksheet I want to go to.

Any help will be, as always, greatly appreciated!

Thanks very much, -Bob in California

 

[VulcanJedi]

if you are running ofc xp at least:
Insert-hyperlink, on the side menu bar, click in this document, select the sheet you want and what cell.

if you want a coded version. try placing this code in the vba project of the workbook you are on, select your sheet, click paste this:
*replace the 1,1 w/ the coordinates of your cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

if activecell = cells(1,1)then
sheets("your sheet name here&quot.select
cells(1,1).select

End Sub Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[DaleWatson123321]

Hi Bob,

This will work...

Insert this Hyperlink:

test2.xls!sheet2!xxx

where "xxx" is a range name you assign to the cell on Sheet2 where you want the cursor to go to.

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DeLaMartre]

Hi Dale,

Thanks for the reply. Unfortunately, as much as I try (changing spacing, adding ', etc., I cannot make this work. I am at work, using Excel 2000 on Windows 2002.

I really do not understand why your solution doesn't work. Any ideas???

Thanks very, very much, Dale,

Bob -Bob in California

 

[DeLaMartre]

Sorry Tranpkp, using Excel 2000.

Thanks for your suggestion, however! -Bob in California

 

[DaleWatson123321]

Bob,

I'm not sure if I have your work address. If you want to email me, I can email you the file back.

I have Office 2000.

Regards, ...Dale dwatson@bsi.gov.mb.ca

 

[DocControlChik]

Hello,
The real experts will probably giggle at me solution but it really works for me.

I have a report that I make every week with a table of contents that points to other pages in the spreadsheet.

Go to the page you want to hyperlink and set the print area

Go to the page that you want to have the hyperlink on.
Right click on the cell that you want to place the hyperlink.
Select hyperlink
Click the button that says bookmark
Expand the defined names (if not already done)
Select the print area you set before.
If you did not edit the cell write something that make sense blah blah

Hope it helps

DocControlChik, NY, NJ

 

[DeLaMartre]

Thanks to everyone who chimed in on this annoying little problem.

The solution for the system I am working on, (Excel 2000, Windows 2000), turns out to be the following:

workbookname.xls#'sheetname'!cellreference

Special thanks to Dale Watson for getting me on track on this! -Bob in California