Erase password

[KIM Chanthan]

Hi dear,

Do you have any rule to enable editing protected worksheet and workbook in excel 2010?
I just lost password.

Thank for help.

 

[Nebu]

Hi:

Use the search box there are ready made vba codes for breaking workbook password and this question have been asked in the past.

Thanks

 

[Kmahraz]

I came across this question several time in this site and I am positive you will find your answer if you did a little search

Here are some posts regarding your subject:
http://forum.chandoo.org/threads/i-want-to-break-password-of-each-files-of-every-sheets.22036

http://forum.chandoo.org/threads/unprotect-all-sheets.21878

http://forum.chandoo.org/threads/all-files-only-first-3-sheets-want-to-unprotect.22888

http://chandoo.org/forum/threads/how-break-particular-sheets-password.26214/#post-156764

http://chandoo.org/forum/threads/how-to-unprotect-password.22720/

 

[iRasim]

Hi KIM Chanthan, I attached file. Try it!!! 100% works

 

[Eloise T]

Since you are using Excel 2010, here's a simpler version with instructions.

 

[KIM Chanthan]

Thanks