Creating a "Next" button to move the user to the next sheet

R

Rob

I have created a program in Excel that is built so a user will start on tab
one and then move through each tab. I want to hide the tabs and have the
user click a button that reads, "Next" or "Back". These buttons will take
them to the next tab or the previous tab.

Can this be done?
 
L

L. Howard Kittle

Hi Rob,

Is it necessary th Hide the tabs, you can do what you want with CTRL + PAGE
UP or PAGE DOWN.

HTH
Regards,
Howard
 
S

stew

What you want cane be done using the Hyperlink function. This is an example
of one that i use. It displays the word "View" in the host cell. You would
replace it with "Next". The Routing Shouyld Be a lot simplier as you are just
going from work Sheet to work sheet
ex
=HYPERLINK("#'Invoices to promoters'!G1","next")


=HYPERLINK("["&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25)&"Road
Managers Package\Tour Managers Spreadsheet.xls]'Tour Managers
Spreadsheet'!b"&((ROW()+39)),"View")
 
Top