visit J.E. McGimpsey's site:
http://mcgimpsey.com/excel/removepwords.html

For more details.

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.
--
Thanks!
Shane W

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

--

Dave Peterson