Use Application.GoTo. E.g,.

Private Sub CommandButton1_Click()
Application.GoTo Worksheets("Sheet1").Range("A1"),True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Richard Bancroft"
wrote in message
...
I realise that you can use the 'VCR' controls to scroll through
the various
tabs but I want the spreadsheet to present a dashboard when
opened which
presents all the worksheet options and from which the user can
navigate to
any of them by pressing a command button. Essentially I am
asking "how do I
program a command button to move the user from one part of a
workbook to
another?"

"Richard Bancroft" wrote:

I have a pricing model with about a dozen worksheets in Excel
2003, so that
there are more worksheet tabs than can be seen without
scrolling. How can I
set up a "dashboard" which lists all the worksheets and allows
the user to
click a button to go to that worksheet?