Table of Contents

[John McCabe]

I had a macro (not view code) to create a list in first tab of all tabs and
to make them hyperlinks. Working with year end report from office that has
many tabs to fill in. Search for table of contents is frustrating - every
site has one ! ! !

 

[Pete_UK]

David McRitchie has a macro to do this here:

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

I think this is what you are asking for - not very clear in your post.

Pete

 

[John McCabe]

Thank You - Thank You Had one from him before but it stopped working - I
just ass u me d it was because of a new excel version. I was wrong, it
works great.. Thanks again.
David McRitchie has a macro to do this here:

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

I think this is what you are asking for - not very clear in your post.

Pete

 

[Pete_UK]

You're welcome, John - David has done all the work, though.

Pete