Skip to Main Content
Excel Macros For Dummies, 3rd Edition
book

Excel Macros For Dummies, 3rd Edition

by Dick Kusleika
March 2022
Beginner content levelBeginner
304 pages
6h 19m
English
For Dummies
Content preview from Excel Macros For Dummies, 3rd Edition

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

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

Excel Macros For Dummies

Michael Alexander

Publisher Resources

ISBN: 9781119844433Purchase Link