View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob O`Bob Bob O`Bob is offline
external usenet poster
 
Posts: 16
Default 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
--