Worksheet name list


Posted by Kurt on June 29, 2001 7:01 AM

Is there a way to get a list of the worksheet names in a workbook onto one worksheet?

I was just give a file with a large number of worksheets. When you go to Properties under the File menu it gives you a list of worksheets under the Contents tab. What I want is a way to get that list into a worksheet.

Thanks.

Kurt

Posted by IML on June 29, 2001 7:19 AM

This is one of the options from the free add-in at www.asap-utilities.com.
Also, remember CPOD's tip to right click on the tab scrolling buttons in the lower left hand corner of the window for quicker navigation on multi-sheet workbooks.

Good luck.



Posted by Kurt on June 29, 2001 7:31 AM

Thanks. I appreciate it.

Kurt