Navigation with arrows eg next/prev pge in Excel?

H

Harris John

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

Harris John

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

Gord Dibben

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
 
E

excelent

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:
 
K

Kevin B

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

Harris John

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
 
H

Harris John

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

Harris John
 
H

Harris John

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
 
Top