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