Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink to last page (2003 SP2)

    Good Morning

    Is it possible in Excel to hyperlink back to the page you have just come from, I have googled and searched the help files but could not find anything. To explain what I am doing

    I have a WB that contains a WS for every Country listed in the ISO, that is some 240, many of these will use a common rate structure that I have placed in another WS rather than placing the same thing in say 50 other WS's.

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlink to last page (2003 SP2)

    I don't think this can be done with hyperlinks, at least not easily, but you could use a macro for this and assign it to a command button, toolbar button and/or keyboard shortcut.

    In a standard module:

    Public shtPrev As Worksheet
    Public shtCurr As Worksheet

    Public Sub GoBack()
    If Not shtPrev Is Nothing Then
    shtPrev.Activate
    End If
    End Sub

    In the ThisWorkbook module:

    Private Sub Workbook_Open()
    Set shtCurr = ActiveSheet
    End Sub

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Set shtPrev = shtCurr
    Set shtCurr = ActiveSheet
    End Sub

    See the attached sample workbook.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to last page (2003 SP2)

    Hi Hans

    That is excellent, thanks for doing that

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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