Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
Hi,
is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
Using event code code.
Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) Const WS_RANGE As String = "A1:A80" If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then Workbooks.Open Filename:= _ "C:\Program Files\Microsoft Office\Exceldata\Book1.xls" ActiveWorkbook.Sheets(Target.Value).Activate End If End Sub Edit the path and filename to suit. Gord Dibben MS Excel MVP On Tue, 10 Nov 2009 11:06:02 -0800, Romileyrunner1 wrote: Hi, is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
www.google.com
http://www.theexceladdict.com/_t/t030609b.htm www.youtube.com http://www.youtube.com/watch?v=3rIHggOP71Y http://www.youtube.com/watch?v=9Pu5QSuGcwU HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Romileyrunner1" wrote: Hi, is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
Something like this should work:
=HYPERLINK("[C:\My Documents\Mybook.xls]"&A2&"!A1",A2) Note that this takes you to the workbook "Mybook", cell "A1" of the sheet called out in cell A2, and displays a friendly name of whatever is in cell A2. You can learn more about the HYPERLINK function in the XL help file. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Romileyrunner1" wrote: Hi, is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
hi
i think your question was answered in the previous post but try something like this.... =HYPERLINK([workbook1.xls]sheet1!$A$1,"gotoit1") regards FSt1 "Romileyrunner1" wrote: Hi, is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to a specific worksheet in another workbook
Check your other post..
If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Hi, is there a way to hyperlink from one workbook to a specific worksheet in another workbook. I have a collumn of numbers from 1-80. I would like to click on each cell and be taken to a corresponding worksheet numbered 1-80 ina diffferent workbook. I can easily go to that workbook but I can`t specify the worksheet: it just takes me to the last viewed worksheet. Any ideas guys? Thanks RR1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to a specific worksheet in another workbook. | Excel Worksheet Functions | |||
Dynamic Hyperlink to a specific workshet on a web published workbook. | Excel Worksheet Functions | |||
hyperlink to a specific worksheet | Excel Discussion (Misc queries) | |||
External hyperlink to a specific page in a workbook | Excel Worksheet Functions | |||
Hyperlink to specific sheet; workbook saved as html | Excel Worksheet Functions |