The macro code of an Excel document can be protected by a password.
Is there a way to detect whether an Excel macro is protected by a specific password? I would like to be able to validate the vba code to be protected by a specific password.
pseudo example (Java):
vbaProject.isProtectedBy("password"); // return true and only true when both the macro code is
protected and the protection password is 'password'.@RickOo,
There is no such option available in the current library, however, we have logged a ticket in our database to investigate this requirement. We will write back here once any update is available in this regard.
This requirement is logged as:
CELLSJAVA-43375 - Check Excel VBA password
Thank you. Where can I keep track of this feature request? What is the link?
@RickOo,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
Please try our latest version/fix: Aspose.Cells for Java v20.12.2 (attached)
Your issue should be fixed in it. We have added a new VbaProject.ValidatePassword() method.
Let us know your feedback.
aspose-cells-20.12.2-java.zip (7.2 MB)