1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Remove password

Discussion in 'The Vault' started by Luke M, Apr 29, 2015.

  1. Luke M

    Luke M Excel Ninja

    Messages:
    9,390
    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.

    Attached Files:

    Last edited: Mar 21, 2018
  2. Sameer.k21

    Sameer.k21 Member

    Messages:
    104
    Hi, I have 64bit version of excel. How can I use this code, please help
  3. Abhijeet

    Abhijeet Active Member

    Messages:
    1,190
    Hi

    Use this File for 64 Bit Version

    Attached Files:

  4. Sameer.k21

    Sameer.k21 Member

    Messages:
    104
    @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.
  5. Niraj Baraili

    Niraj Baraili Member

    Messages:
    95
    Hi Luke,

    Any luck on cracking a excel workbook password which is locked for viewing.
  6. civilian932

    civilian932 New Member

    Messages:
    1
    THANKS IT WORKED LIKE A CHARM... HIGHLY APPRECIATED
  7. David Lam

    David Lam New Member

    Messages:
    29
    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 :(
  8. Luke M

    Luke M Excel Ninja

    Messages:
    9,390
    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.
    David Lam and Thomas Kuriakose like this.
  9. David Lam

    David Lam New Member

    Messages:
    29
    Ah Thank you. I was using the 64 version and didn't see anything. I got it now :)
  10. ferocious12

    ferocious12 Member

    Messages:
    36
    Hi is there a similar macro for MS Word files & projects ?
    sathishsusa likes this.
  11. SirJB7

    SirJB7 Excel R┼Źnin

    Messages:
    8,894
    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!
    ferocious12 likes this.
  12. abcd1234

    abcd1234 New Member

    Messages:
    1
  13. AllisonE

    AllisonE New Member

    Messages:
    1
    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".

Share This Page