![]() |
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 |
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 |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com