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: