On a Contents sheet you could have a series of hyperlinks so that if
you click on one you will be taken to that sheet. On each of the other
sheets you could have one hyperlink to take you back to the Contents
sheet. For example, enter this formula in H1 of one of the sheets:

=HYPERLINK("#Contents!A1","Back to Contents")

This will display the message Back to Contents and if you click on
this cell it will send you to A1 of the Contents sheet. Copy this
formula to H1 of all the other sheets.

Then in the Contents sheet itself, you would have a series of formulae
like:

=HYPERLINK("#Sheet1!A1","Sheet1")
=HYPERLINK("#Sheet2!A1","Sheet2")

and so on. You need to change the Sheet1, Sheet2 etc in the first part
of the formula to match your sheet names, but you can have whatever
message you want in the second part of the formula. You can have this
list starting in, say, A3.

Hope this helps.

Pete



On May 20, 1:16 am, Shreekant Patel wrote:
Hi

Hopefully someone can help me on this.

I have in one Excel file, 12 worksheets each containing a lot of
data. What I would like is a set of buttons or a toolbar which would
have buttons for each worksheet that I can click on to open the
relevant worksheet.

Is this possible?

Clicking on the sheet tabs on the bottom gets frustrating as each
sheet name is long so scrolling is necessary and annoying.

Any help would be greatly appreciated.

Thanks

SP