If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set up a botton on Excel 2003 to go to the next sheet?
I want to create a "Next Page Button" on an Excel 2003 spreadsheet to go to
the next sheet. When entries are complete a person can just click the "button" and go to the next steps (next sheet) in the spreadsheet. Thanks, Bruce |
#2
|
|||
|
|||
How do I set up a botton on Excel 2003 to go to the next sheet?
You CAN press Ctrl/Page down, but if you insist on a button:
Sub NextSheet() On Error Resume Next 'may be on last sheet Sheets(Activesheet.Index+1).Activate End Sub "Bruce" wrote: I want to create a "Next Page Button" on an Excel 2003 spreadsheet to go to the next sheet. When entries are complete a person can just click the "button" and go to the next steps (next sheet) in the spreadsheet. Thanks, Bruce |
Thread Tools | |
Display Modes | |
|
|