How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?

Dear NimRod and MarvinP,

I respect your views and completely agree with you that this is too simple a request to move between the tabs but the reason of asking for its is to Save the Time by taking the pointer to always a particular cell from where there the person can take control of the Sheet for Printing the Sheets contents which are already formatted for the Print Preview..

Hope you understand..!

I have tried to make up some code of my own with great help from the Forum and TMShucks inital code however theres something which is missing as I am getting an error mentioning that "REFERNCE IS NOT VALID"

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Range("e1").Value = "Go to " & ActiveSheet.Previous.Name
If Target.Address = "$E$1" Then
'Target.Value = Time
ActiveSheet.Hyperlinks.Add _
Anchor:=Range("E1"), _
Address:="", _
SubAddress:=ActiveSheet.Previous.Name, _
TextToDisplay:="Go to " & ActiveSheet.Previous.Name


End If
End Sub

Would appreciate if someone could just tweak a little..
I think instead of the "ActiveSheet.Hyperlinks.Add _" it needs to be the Previous SHeet...


Warm Regards
e4excel