software

I have a workbook with about 40 worksheets, I would like to create 1
worksheet that woud provide the user with a list of all the worksheets, and
then be able to click on that name and have it take them to that worksheet.
sort of a control panel that they can go to to find the sheet they are
looking for instead of going through all the tabs.

Any easy thought on how to do this?See

www.mvps.org/dmcritchie/excel/buildtoc.htm

In article gt;,
quot;JackRquot; gt; wrote:

gt; I have a workbook with about 40 worksheets, I would like to create 1
gt; worksheet that woud provide the user with a list of all the worksheets, and
gt; then be able to click on that name and have it take them to that worksheet.
gt; sort of a control panel that they can go to to find the sheet they are
gt; looking for instead of going through all the tabs.
gt;
gt; Any easy thought on how to do this?