I have an encrypted xlsb file that I would like to allow file properties to be visible when the file is closed. My IT department would like to use the "Comments" value to store a value that can be read by other systems without opening the file. I tried running the code shown below which I found on https://msdn.microsoft.com/en-us/vb...ook-setpasswordencryptionoptions-method-excel but it did not work and a note at the bottom of the web page notes that it will not work on xlsb documents. Is there another way to make those values visible or different way to accomplish this? The file will be saved by multiple users with various file names so we are looking for a way to get a revision number of the starting document.
Sub SetPasswordOptions()
ActiveWorkbook.SetPasswordEncryptionOptions _
PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
PasswordEncryptionAlgorithm:="RC4", _
PasswordEncryptionKeyLength:=56, _
PasswordEncryptionFileProperties:=False
End Sub
Thank you.
Sub SetPasswordOptions()
ActiveWorkbook.SetPasswordEncryptionOptions _
PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
PasswordEncryptionAlgorithm:="RC4", _
PasswordEncryptionKeyLength:=56, _
PasswordEncryptionFileProperties:=False
End Sub
Thank you.