Hi

That would be an idea.

BTW: Here is some information for your reference.
I think you may try the SheetFollowHyperlink event, which will be fired
when you click a hyperlink.
But based on my research, there is no such an event which will be fired
when you back to the oringal sheet.

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target
As Hyperlink)
Dim s() As String
s() = Split(Target.Name, "!")
Application.Sheets(s(0)).Visible = True
End Sub


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.