Try the macro recorder whilst doing the CTRL + page up or down.

You will get this..................

Sub Macro1()
ActiveSheet.Next.Select
End Sub

or this...................

Sub Macro2()
ActiveSheet.Previous.Select
End Sub

Assign each to a button.


Gord Dibben MS Excel MVP


On Sat, 27 Oct 2007 11:49:00 -0700, Harris John
wrote:

Thanks, new tip which I did not know, but I am lazy and want an arrow
on-screen to click on for either back one sheet/forward one sheet.

"excelent" wrote:

CTRL+PG.DOWN/UP

"Harris John" skrev:

I use multiple sheets and hide the tabs, but would appreciate being able move
back and fore between them - as is possible in Access.