Chapter 4

Working with Workbooks

In This Chapter

arrow Creating a workbook

arrow Saving a workbook when a cell is changed

arrow Saving a workbook before you close it

arrow Protecting and unprotecting a workbook

arrow Opening a user-defined workbook

arrow Determining whether a workbook is open or exists

arrow Printing all workbooks in a directory

arrow Creating backups of your workbook

A workbook is not just an Excel file; it's also an object in Excel's Object model (a programming hierarchy that exposes parts of Excel to VBA).

You can reference workbooks through VBA to do cool things like automatically create new workbooks, prevent users from closing workbooks, and automatically back up workbooks. In this chapter, you explore a few ...

Get Excel Macros For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.