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"
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
Bookmarks