Switchboards

[Guest]

Is it possible to create a switchboard in Excel worksheets in a similiar
manner to the switchboards generated in Access to allow easy navigation of a
workbook?

thanks

Brian

 

[Ken Johnson]

Hi Brian,

I think the easiest way is to...

1. Insert a new worksheet.
2.If the new worksheet is not already the first worksheet then click
and drag its sheet tab to the left to get it there.
3.Convert this new sheet to act like a table of contents by inserting
Hyperlinks into a number of its cells. For example, click a cell on the
new worksheet, the following steps will place a hyperlink in that cell
which will take you to sheet2...

a) go Insert|Hyperlink

b) in the Insert Hyperlink dialog click on "Place In This Document"
under the "Link to:" heading

c) in the "Or select a place in the document" box click on "Sheet2"

d) Edit the value that appears in the "Text to display" box to what
ever you want to appear in the cell on sheet1, the table of contents.

e) Click OK

Now when you click on that cell you will be taken to sheet2.

Just repeat this process for each of your worksheets

You could also reserve a cell on each of you sheets for a hyperlink to
take you back to the table of contents sheet.

Ken Johnson

 

[Ken Johnson]

Hi Brian,

Just discovered you can insert a hyperlink onto a shape such as a
textbox or any of the autoshapes such as the rectangle with rounded
corners.

Just in case you prefer buttons with normal looking text to cells with
blue hyperlink text.

Also, I access these discussion groups via Google Groups, which has a
facility for searching the group for certain topics. I did a search for
"Table of contents" and it came up with over 600 items. You might want
to check that out.

Ken Johnson

 

[Mark Ivey]

Give this site a try...

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

--
Mark Ivey
Is it possible to create a switchboard in Excel worksheets in a similiar
manner to the switchboards generated in Access to allow easy navigation of a
workbook?

thanks

Brian