March 2022
Beginner
304 pages
6h 19m
English
Chapter 4
IN THIS CHAPTER
Creating a new workbook from scratch
Saving a workbook when a particular cell is changed
Saving a workbook before closing
Protecting an existing workbook on close
Unprotecting an existing workbook on open
Opening a workbook to a specific tab
Opening a specific workbook defined by the user
Determining whether a workbook is already open
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 ...