Quote Originally Posted by nimrod View Post

A) clicking on sheets tab that requires no scroll (i.e. next sheet)
B) rt clicking on the bottom bars arrows and selecting from popup sheet list

Ctrl + i = goto Index sheet
Ctrl + f = Forward to next sheet
Ctrl + b = Back one sheet

BY-THE-WAY:
You do know there is a built in Index of sheet ? i.e. if you right-click over the arrows in the lower left corner of excel sheet a sheet index will popup

EXCELS DEFAULT PAGE NAVIGATION
Move to the next sheet in the workbook. CTRL+PAGE DOWN
Move to the previous sheet in the workbook. CTRL+PAGE UP
Thanks a lot NIMrod,
I like the approach you have mentioned of CTRL + I, B or F of all however the reason of Automating it was to go not only in the Sheet but also to a particular cell like H2 in all sheets after clicking..

There are lot of Print-Outs to be taken from this SHeet and therefore wanted to make it easier for the person to move between SHeets.

Actually, I didnt know about the default Index you and The KeyBoard ShortCuts mentioned..so grateful to you for the same,..

If I am not asking too much can this code be placed in the Click or Double-Click Events of these three cells so that I can copy an replicate the same in several Sheets vy CTRL+SELECTING Al the Sheets..

That would be twice as nice as getting the Functionality alongwith USER-FriendliNESS..

Thanks a lot NimROd and MarvinP I am going through the Links you provided to assess which optin would better suit my requirement.

SO thanks to both of you for the help..

Regards
e4excel