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