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]