Prev: vlook on different tabs based on value
Next: hr worksheet counting days missed
From: Bruce on 5 May 2010 14:20
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
From: Bob Umlas, Excel MVP on 5 May 2010 15:23
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
 | 
Pages: 1
Prev: vlook on different tabs based on value
Next: hr worksheet counting days missed