Summary

This chapter presents 16 Ready-to-Use Excel Macros for Automating Worksheet Tasks. Macros for adding and naming a new worksheet, deleting all but the active worksheet, hiding all but the active worksheet, unhiding all worksheets in a workbook, moving worksheets around, sorting worksheets by name, and grouping worksheets by color are discussed in the chapter. Copying a worksheet to a new workbook, creating a new workbook for each worksheet, printing specified worksheets, protecting and unprotecting all worksheets, and creating a table of contents for worksheets are also presented.

The full text of this article hosted at iucr.org is unavailable due to technical difficulties.