Forum Discussion
How do I unlock a Workbook, Worksheet, VBA Project, without a password?
I wonder if the "Unlock a worksheet" section is correct. As far as I know, protecting a worksheet (with or without password) writes a special tag into the sheet's xml file in the zip container. You can still open the zip file and access the sheet's xml file.
Similarly the workbook structure protection does not make it impossible to rename the file to zip to look inside.
It is only the file, open password protection that encrypts the file and disallows opening it as a zip file.
Thanks for your feedback.
You can unlock the worksheet using zip or VBA, I think it is also no problem to access the XML as you mention.
Protecting the workbook structure is also no problem to look inside the zip file as you mention. My aim was to define the differences between password protection of the file, worksheet protection and VBA Project protection for the user and to show the differences themselves and in a possible unlocking.
I intentionally did not go into it in more detail, such as the workbook structure or cell locking.
This article is intended for users who "only" use Excel as an additional tool or who are new to the subject.
Thanks again for your feedback and definitions.