Link

[Guest]

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

 

[Gord Dibben]

Insert>Hyperlink 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/micr...464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25



Gord Dibben MS Excel MVP