Link

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobbykm - 06 Oct 2007 17:36 GMT

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

Reply to this Message

Gord Dibben - 06 Oct 2007 18:04 GMT

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/microsoft.public.excel.worksheet.functions/browse
_frm/thread/935f5e174087f636/02c19464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 7 lines]
>Thanks
>Bobby

Reply to this Message