Navigation with arrows eg next/prev pge in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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:
 
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.
 
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
 
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
 
Back
Top