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?