Table of Contents

K

Kevin

Hi

I have a wb with many sheets. I want to have one sheet to help the user navigate the wb. essentially it is a table of contents with each item a the name of a different tab. I want the user to be able to mouse over the required sheet, click and be taken to the sheet. Is this possible

Regard
Kevin
 
J

Jason Morin

Here is some code posted by Bob Phillips that'll
accomplish what you want:

http://tinyurl.com/3xcvv

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi,

I have a wb with many sheets. I want to have one sheet to
Click to expand...
help the user navigate the wb. essentially it is a table
of contents with each item a the name of a different tab.
I want the user to be able to mouse over the required
sheet, click and be taken to the sheet. Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Consolidation Table from Different Excel Tabs with Different Format 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Table of Contents 1
code to unhide tabs based on cell contents 7
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Excel does not accept text format! 0

Top