Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346