Workbook.PasswordEncryptionFileProperties (Excel)

True if Microsoft Excel encrypts file properties for the specified password-protected workbook.

Use the SetPasswordEncryptionOptions method to specify whether Excel encrypts file properties for the specified password-protected workbook.

Dim booPasswordEncryptionFileProperties As Boolean
booPasswordEncryptionFileProperties = ActiveWorkbook.PasswordEncryptionFileProperties