Reverse Hyperlink

[cmeier7]

Is there any way to create a reverse hyperlink in Excel? It would be something that would mimic the back button in an internet browser, only my hyperlinks are not URL oriented- they navigate through a workbook. So for example, if a hyperlink takes me to one worksheet within a workbook, is there a way to create a hyperlink that will take me back to the previous sheet?

 

[timorrill]

Here is example of the functionality you are asking about.

I have three worksheets: Sheet1, Sheet2, and Sheet3. On each worksheet there are hyperlinks to other worksheets, plus a hyperlink that says "Back". For example, Sheet1 looks like this:

Excel Workbook
	A	B
1	Back	Sheet2
2		Sheet3
Sheet1

Excel 2003

Here is what I did to get the Back hyperlink working as expected:

(1) Create a new module to and add the following code:

Global PrevSheet As Worksheet

(2) In the "ThisWorkbook" module, add the following code:

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
    If Target.Name<> "Back" Then
        Set PrevSheet = Sh
    ElseIf Not PrevSheet Is Nothing Then
        PrevSheet.Activate
        PrevSheet.Range("A1").Select
    Else
        Exit Sub
    End If
End Sub

This seems to do the trick for my basic setup. Undoubtedly you will need to configure this for your particular needs.