Linking to a worksheet in a separate workbook
 

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.


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile: http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=548094

Linking to a worksheet in a separate workbook
 

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 tabview codeinsert 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
--
Don Guillett
SalesAid Software

"AcesUp" wrote in
message ...

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.


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile:
http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=548094

Linking to a worksheet in a separate workbook
 

Don,

Perfect thanks, seems so simple in heinsight

Many Thanks,
AcesUp


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile: http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=548094

Linking to a worksheet in a separate workbook
 

glad to help

--
Don Guillett
SalesAid Software

"AcesUp" wrote in
message ...

Don,

Perfect thanks, seems so simple in heinsight

Many Thanks,
AcesUp


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile:
http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=548094