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

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.

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.

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.

Well then use these 2 lines in 2 macro
move back:
ActiveSheet.Previous.Select
forward:
ActiveSheet.Next.Select


make 2 arrows from drawing toolbox on all sheets hmm :-)
or
bottuns from Formulatoolbox/Controtoolbox
or
put 2 macrobottons on menuline


or
insert a doubleclick events code in ThisWorkbook

"Harris John" skrev:

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.

To the left of the the first visible toolbar are 4 scroll buttons First
Sheet, Previous Sheet, Next Sheet and Last Sheet. These 4 button only move
the the view and not the focus, so once you get to the sheet you want to work
on you will need to click on a cell in that worksheet to move focus to your
select sheet.
--
Kevin Backmann


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

Many thanks Kevin B yes I do use these, however I want yo hide the Tabs, so
this will not work in this instance. Thanks again. It has pointed me in the
right direction though!

Harris John
"Kevin B" wrote:

To the left of the the first visible toolbar are 4 scroll buttons First
Sheet, Previous Sheet, Next Sheet and Last Sheet. These 4 button only move
the the view and not the focus, so once you get to the sheet you want to work
on you will need to click on a cell in that worksheet to move focus to your
select sheet.
--
Kevin Backmann


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

Gord, this got it in one, just what I was looking for. Many thanks.

Harris John

"Gord Dibben" wrote:

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.

Great, thanks. This is what I want. Have sussed it out from another response.

Can you expand on the double click events code, and buttons on the menuline
- I have never done this?

Harris John

"excelent" wrote:

Well then use these 2 lines in 2 macro
move back:
ActiveSheet.Previous.Select
forward:
ActiveSheet.Next.Select


make 2 arrows from drawing toolbox on all sheets hmm :-)
or
bottuns from Formulatoolbox/Controtoolbox
or
put 2 macrobottons on menuline


or
insert a doubleclick events code in ThisWorkbook

"Harris John" skrev:

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.