ExcelBanter - how do i create table of contents links/pg for multiple workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i create table of contents links/pg for multiple workbooks (https://www.excelbanter.com/excel-worksheet-functions/144990-how-do-i-create-table-contents-links-pg-multiple-workbooks.html)

JRoss

how do i create table of contents links/pg for multiple workbooks

Gord Dibben

how do i create table of contents links/pg for multiple workbooks

Use hyperlinks to switch to the workbook of your choice.

David McRitchie covers TOC using hyperlinks at his site.

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

David's work is mainly on sheet navigation within one workbook but same
principles apply to multiple workbooks.

Gord Dibben MS Excel MVP

On Sun, 3 Jun 2007 12:41:00 -0700, JRoss
wrote:

All times are GMT +1. The time now is 12:33 PM.