View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Navigation with arrows eg next/prev pge in Excel?

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.