I have a cover page, Sheet1, with table of contents on lines A1-A7. I want
to click on any of the cells, A1-A7, and have that corresponding sheet come
up.
Ex.
A
1 Names - Sheet2
2 address - Sheet3
etc

Thanks
Bobby

InsertHyperlink or right-click on A1 and Hyperlink.

Select Sheet2 from Place in this document.

Have you thought about how you will get back to the cover page?

How about a sheet navigation bar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro?

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25



Gord Dibben MS Excel MVP



On Sat, 6 Oct 2007 09:36:02 -0700, Bobbykm
wrote:

I have a cover page, Sheet1, with table of contents on lines A1-A7. I want
to click on any of the cells, A1-A7, and have that corresponding sheet come
up.
Ex.
A
1 Names - Sheet2
2 address - Sheet3
etc

Thanks
Bobby