Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global buttons
I have a workbook with many worksheets. I want to define 2 global buttons
called Prev Worksheet and Next Worksheet for ease of navigation. I have the code that does the navigation but can't seem to find a way to define these buttons globally for the workbook. When I try adding them to a specific worksheet, I get a Private Sub PrevWorksheet_Click() routine on that worksheet. Now I can put the code there but then I'd have to have a copy on every worksheet. I think I need to add something to the ThisWorkbook object can't seem to figure out how to do that. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Control Buttons vs. Command Buttons | Excel Programming |