macro to crack passwords
 

whylite wrote:
I password protected a spread sheet with a number and then used a macro to
crack the password. Within the macro I requested that it give me a message
box telling me the number that it used to unlock the page. I was amazed to
find that the number did not match the password I had used. I relocked the
page with the original password and the tried to unlock the page with the
number that the macro gave me and sure enough the page unlocked. I am
wondering is it also possible that if I use letters to protect a page that
the result would be the same? That it could be possible to unlock the page
without have the correct password.


It does not store the password, but rather a "hash" value computed from it.
It is not particularly unusual that more than one password string will hash
to the same stored value. That's just how secure it actually is.



Bob
--