View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default 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