list worksheet names within a notebook

[GVS]

Is there a way to list all of the worksheets within the active workbook and
created a hyperlink to each? I have seen it before but it has been a few
years.

TIA

GS

 

[JMay]

Check this out - it will blow you away!!

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

Hope it helps (you)... HTH

 

[GVS]

That's the one I saw. Extremely useful. Thanks for pointing me in the right
direction!

GS