Summary

This chapter presents 15 ready-to-use excel macros for working with workbooks. Macros for creating a new workbook from scratch, saving a workbook when a particular cell is changed and before closing, opening a specific workbook defined by the user, determining whether a workbook is already open, opening all workbooks in a directory, preventing the workbook from closing until a cell is populated, and creating a backup of a current workbook with today's date are few of them presented in the chapter.

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