Linking to a worksheet in a separate workbook

A

AcesUp

All,

I have several workbooks which I would like to make more user friendly
by creating some form of menu and navigation system.

Is there a way to add a link on a workbook that once clicked will open
up another workbook and take the user straight a s specific worksheet?

I've search the forums but not been able to locate the answer so
apologies if this is a repeat question.

Many Thanks,
AcesUp.
 
D

Don Guillett

The macro is your friend. Recorded this
Sub Macro1()
' Macro1 Macro
' Macro recorded 6/3/2006 by Don Guillett
Workbooks.Open Filename:="C:\yourfolder\yourfilename.xls"
End Sub

modified to test
Sub gotoworkbooksheet()'yourfilename in cell a1
mwb = "C:\yourfolder\" & Range("a1") & ".xls"
Workbooks.Open Filename:=mwb
Sheets("sheet3").Select
End Sub

modified for double click event.
right click sheet tab>view code>insert this
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column <> 1 Then Exit Sub
mwb = "C:\yourfolder\" & Target.Value & ".xls"
Workbooks.Open Filename:=mwb
Sheets("sheet3").Select
End Sub
 
Top