+ Reply to Thread
Results 1 to 4 of 4

Linking to a worksheet in a separate workbook

  1. #1
    Registered User
    Join Date
    08-22-2005
    Posts
    9

    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.

  2. #2
    Don Guillett
    Guest

    Re: 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 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
    --
    Don Guillett
    SalesAid Software
    [email protected]
    "AcesUp" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




  3. #3
    Registered User
    Join Date
    08-22-2005
    Posts
    9
    Don,

    Perfect thanks, seems so simple in heinsight

    Many Thanks,
    AcesUp

  4. #4
    Don Guillett
    Guest

    Re: Linking to a worksheet in a separate workbook

    glad to help

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "AcesUp" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1