Lesson 4 - Workbooks (Information / Properties)
Workbook Properties
We run through how to print workbook properties to the Immediate Window using Debug.Print:
- Workbook name
- Workbook path
- Workbook full name (= name + path)
- Workbook saved status
- Workbook password protection status
BONUS - I show you how to use the Immediate Window to check workbook properties without creating a new subroutine. You can extend this technique to get the properties of any Excel object without creating a new subroutine.
Write your comments and feedback below
- If you have questions or comments about this lesson, write it in the section below.
- Alternatively you can email the instructor Victor at [email protected]
0 comments