April 2006
Beginner
1114 pages
98h 16m
English
workbook.PasswordEncryptionAlgorithm
Returns a string indicating the type of encryption used for a workbook. The following code displays the encryption properties for a workbook in the Immediate window:
Set wb = ThisWorkbook
Debug.Print "Encrytpion algrorythm: " & wb.PasswordEncryptionAlgorithm, _
"Encrypt properties? " & wb.PasswordEncryptionFileProperties, _
"Key length:" & wb.PasswordEncryptionKeyLength, _
"Provider: " & wb.PasswordEncryptionProviderIf a workbook is not encrypted, the PasswordEncryptionAlgorithm is OfficeStandard.
Read now
Unlock full access