Tool Bar In Excel With Macros
 

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

Tool Bar In Excel With Macros
 

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 MVP


"Mike Hebblewhite" wrote in message
...
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