Did you know that there is more than the one password you have entered when protecting a sheet or workbook that can remove the protection?
In fact, I found 8960 password combinations for one password entered (three digits) that remove the protection!
Using a relatively simple VBA macro, you can crack a three digit password in just three seconds, four digits in 24 seconds, five digits in less than 100 seconds maximum.
Even for nine digit passwords, it will not take longer than seven hours to crack them!
All you need to run through in the first loop is characters 128 and 129, last loop characters 32 through 255 and all loops in between through characters 126 through 129.
For users trying to protect their work this means they should use at least 10 characters for their passwords!
Bookmarks