• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove password

Luke M

Excel Ninja
A common request across the Excel forums is looking for some way to remove a password from the worksheet/workbook/VBA project.

Take note, putting a password on any of these items does not make it secure, it only slows someone down from messing things up. With that mindset, here's the file I use for cracking passwords. We've talked about these various methods before. The point of this thread is just to put it into the Vault for future reference, and to put all the methods in a single locations. Attached file will let you remove all worksheet, workbook, and VBA passwords. At last test (Jan 2015), works on Excel 2003, 2007, 2010. For 2013, works on 32-bit only.

I'm not taking credit for developing these codes, just wanted to have them in 1 handy location for others to find.

PS. Password required to open a file is not covered by this tool.
 

Attachments

Last edited:
@Abhijeet Thank you brother. Let me try this :)

I got another macro file which was build for 32bit, However I got 64bit version now.

any help on how to change or what to change on it.
 

David Lam

New Member
Hi, how do I use this? Does it come with instructions? I attempted to run the modules in Alt+F11. I got the notification it says that it "VBA Project is unprotected!" but failed to unlock the password :(
 

Luke M

Excel Ninja
Hi, how do I use this? Does it come with instructions? I attempted to run the modules in Alt+F11. I got the notification it says that it "VBA Project is unprotected!" but failed to unlock the password :(
Don't run the macro from the VBE, but from the workbook. As instructions state on the worksheet in file, you need to open the file you want to unprotect, then run the macro. To run a macro, you can press Alt+F8 to bring up Macro menu, then choose the one you want to run.
 

SirJB7

Excel Rōnin
Hi, ferocious12!
You always have the option of commercial software. It's not strange to forget a password for Excel files, but it's a bit strange to forget both Excel and Word and maybe Powerpoint and co. files. Unless you're not their authorised owner. Despite of the legality of that actions (intention to break into protected software) which should be of legal and moral concern, there's software specifically developed for these, for example:
https://www.elcomsoft.com/aopb.html
Regards!
 

AllisonE

New Member
In addition to using VBA, manually deleting the encrypted password may be helpful in removing the Excel password.
Open Excel > click on File > Information and Permissions Options > click the "Encrypt with password" option and clear the password box > "OK" to delete the password > "Save".
 

Daniel.C

New Member
This is really awesome! I have been looking for solution like this on a .xla file for a while. Finally got it here.
I am running excel 2007 on Windows 7 pro 64 bit. 32 bit version works well.
Thanks again!
 

mcblanch

New Member
A common request across the Excel forums is looking for some way to remove a password from the worksheet/workbook/VBA project.

Take note, putting a password on any of these items does not make it secure, it only slows someone down from messing things up. With that mindset, here's the file I use for cracking passwords. We've talked about these various methods before. The point of this thread is just to put it into the Vault for future reference, and to put all the methods in a single locations. Attached file will let you remove all worksheet, workbook, and VBA passwords. At last test (Jan 2015), works on Excel 2003, 2007, 2010. For 2013, works on 32-bit only.

I'm not taking credit for developing these codes, just wanted to have them in 1 handy location for others to find.

PS. Password required to open a file is not covered by this tool.
This is a brilliant piece of code @Luke M.
Thankyou. It solved a problem that has plagued me and my company for some time because we can't find the contractor who did the work for us and we need to make some changes.

I found this forum because if this problem and as your newest member, I'm very keen to contribute and learn. Thanks for setting this up.
 
Top