Is there a way to make a link to a specific tab in excel?

C

Carlee

Is there a way to make a link to a specific tab in excel? I have a workbook
with many tabs and I want to make an first page that has links to go to
specific tab when clicked.
 
M

Mike H

Pick a cell on the first page and right click - hyperlink - "place in this
document" and you will see a list of sheet names. your done.

Does that work?

Mike
 
G

Gary''s Student

Say we start with Book1.xls and Sheet1.

In A1 enter:

=HYPERLINK("#Sheet2!A1","sheet2")

This will create a "jump-able" link to Sheet2.

BY THE WAY to jump back just use ALT-BACKARROW
 
D

Don Guillett

I use this in a menu workbook to goto a sheet or workbook if the name typed
in a cell.
Right click sheet tab>view code>insert this>type in the name(s) of your
sheets or use

Private Sub Worksheet_BeforedoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
GetWorkbook ' calls another macro to do that
Else
Application.Goto Sheets(ActiveCell.Value).Range("a4")
End If
Application.DisplayAlerts = True
End Sub
Sub listsheets()
For i = 1 To Worksheets.Count
Cells(i, "a") = Sheets(i).Name
Next i
End Sub
 
Top