ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set up a botton on Excel 2003 to go to the next sheet? (https://www.excelbanter.com/excel-worksheet-functions/263184-how-do-i-set-up-botton-excel-2003-go-next-sheet.html)

Bruce

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

Bob Umlas, Excel MVP

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