MakeTable of Contents with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a table of contents that will refrence the spreadsheet tabs
insert them into the TOC worksheet and hyperlink them automatically to their
corresponing sheet. This needs to work for any amount of spreadsheets. thanks
a bunch guys for your help.
 
Hi
use the HYPERLINK() function.
eg: say in book 'my book.xls' one titlle is cell B2 of sheet3
in the main sheet, enter:
=HYPERLINK("[my book.xls]sheet3!a1", sheet3!B2)

regards,
sebastien
 
You must log in or register to reply here.

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

Macro to generate list of folders 2
Read contents of #Name cell 3
Excel Import Comments 3
Accurately reading the contents of another spreadsheet 6
Click on a hyperlink to hide or show a spreadsheet 4
Email hyperlink that subject line will reference cell content 1
Count cells with content in different color background 2
Table of Contents, adjustment to the left, word 2010 7

Back
Top