Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Synchronizer: in my opinion, best diff tool for excel. | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel Tool Bar Gone | Excel Discussion (Misc queries) | |||
Excel 97 macros to Excel 2003 | Excel Worksheet Functions | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |