software

Hello,
Im trying to create a toolbar that takes you through a large report, it
contains a 'Home' button which returns you to the index tab (Thats an easy
on!) a 'Last Sheet' button that returns you to the previous tab and a 'Next
Sheet' button which takes you to the next tab.

What's the easiest way to get this to work, and how woul i go bout writing a
script to make it work?

Thanks

Mike,

Assigne these macros to two buttons:

Sub LastSheet()
On Error Resume Next
Worksheets(ActiveSheet.Index - 1).Activate
End Sub

Sub NextSheet()
On Error Resume Next
Worksheets(ActiveSheet.Index 1).Activate
End Sub

HTH,
Bernie
MS Excel MVPquot;Mike Hebblewhitequot; gt; wrote in message
...
gt; Hello,
gt; Im trying to create a toolbar that takes you through a large report, it
gt; contains a 'Home' button which returns you to the index tab (Thats an easy
gt; on!) a 'Last Sheet' button that returns you to the previous tab and a 'Next
gt; Sheet' button which takes you to the next tab.
gt;
gt; What's the easiest way to get this to work, and how woul i go bout writing a
gt; script to make it work?
gt;
gt; Thanks