Chapter 4

Working with Workbooks

IN THIS CHAPTER

Bullet Creating a new workbook from scratch

Bullet Saving a workbook when a particular cell is changed

Bullet Saving a workbook before closing

Bullet Protecting an existing workbook on close

Bullet Unprotecting an existing workbook on open

Bullet Opening a workbook to a specific tab

Bullet Opening a specific workbook defined by the user

Bullet Determining whether a workbook is already open

Bullet Determining whether a workbook exists in a directory

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

This means ...

Get Excel Macros For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial