Excel Macros For Dummies

Chapter 4

Working with Workbooks

In This Chapter

Creating a workbook

Saving a workbook when a cell is changed

Saving a workbook before you close it

Protecting and unprotecting a workbook

Opening a user-defined workbook

Determining whether a workbook is open or exists

Printing all workbooks in a directory

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 ...