Wednesday, 8 January 2014

VBA password remover

Hi,

I would like to present a simple macro (in a form of .xlsm workbook) which allows to 'remove' password protection from VB Project in '.xlsm' files. It was tested on the workbooks created in Excel 2007/2010. Macro works by the algorithm described in my previous post, so in fact it changes any password in VBA Project to 'macro'.

File stored here:
https://drive.google.com/file/d/0B6sFi5sSqEKbbTJBdC1LS0dYMUE/edit?usp=sharing
Posted by at

55 comments:

  1. DEAR Inventory Implementation Partner28 February 2014 at 10:43

    Hi
    It dont work with .Xlsm files, I have checked it two files, error message when you Debug is: tmpWB=Nothing

    ReplyDelete
    Replies
    1. Anton1 March 2014 at 01:22

      Hi,
      it does work with .xlsm files, it's only file format that this macro can work with. The error you get can be related to many thing - version of your Excel, environment on witch Excel is working (Windows, libraries, ..), specific the file that you're trying to unlock.

      But what exact error did you get (error number and description)?

      Delete
    2. Sanjeev Arora29 June 2015 at 01:01

      It didn't worked for me too. Error message "File don't have VbaProject!". The file do have VBA code and ask for password which I forgot.

      Delete
    3. Unknown11 June 2017 at 21:36

      In such situation you can take the help of third party VBA Excel password remover tool which allows you to remove lost and forgotten password of Excel VBA file.
      Tool link: http://www.vbapasswordremover.org/

      Delete
  2. Cüneyt UÇ5 June 2014 at 10:02

    First I have to tell that my english is not perfect. But I want to tell that You save my life So Thank you so much friend. I prepared an excel utility 1 month ago and ı protect the vba.. Then As you know I forgot it. Today my boss told me That He wants to excel files in tomorrow morning. This was very important for me really you save my life. Thank you very very very much friend.

    ReplyDelete
    Replies
    1. Anton5 June 2014 at 10:28

      Mine English either :). I'm glad that it helped you.

      Delete
  3. vimal30 June 2014 at 04:29

    Hi Anton,
    I could successfully do it once. But every subsequent attempt on same file, i got error message "File don't have VbaProject!"
    pls help!!

    ReplyDelete
    Replies
    1. Anton15 August 2014 at 02:30

      Hi,

      Try another version of tool 'Excel Unlocker.xlsm' (https://drive.google.com/file/d/0B6sFi5sSqEKbLUIwUTVhY3lWZE0/edit?usp=sharing) or send me your file I can have a look.

      Delete
    2. Unknown25 February 2017 at 02:03

      not work

      Delete
  4. max414 September 2014 at 05:05

    Wonderful, worked like a charm.
    Thanks!

    ReplyDelete
  5. Unknown30 September 2014 at 03:20

    Please send me ur id so that I can send u the file.

    My id is niladri.biswas2005@gmail.com

    ReplyDelete
  6. cg18 October 2014 at 07:01

    Anton, i'm facing a similar issue where the algorithm removes the vba password, however then opening the macro, it still prompts me for a password. Can you help? many thanks. cg

    ReplyDelete
    Replies
    1. Anton23 October 2014 at 03:09

      I don't really understand your problem, this tool not removes the password from VBA Project but change it to 'macro', so unless you change settings in VBAProject Protection properties project will remain password protected.

      Delete
  7. wahyu disyah31 October 2014 at 06:57

    Please send me ur id so that I can send u the file.

    My id is willywahyu46@gmail.com

    ReplyDelete
  8. Unknown6 November 2014 at 22:33

    Your program is wonderful.
    There is one kind of question.
    vba source file
    oApp.Namespace (CopyFname) .items.Item ("xl"). Getfolder.CopyHere FileNameFolder & "\ vbaProject.bin"
    What is the force must be modified to overwrite without overwriting the message?

    ReplyDelete
    Replies
    1. Anton6 November 2014 at 22:51

      I'm sorry, but didn't understand your question; about what message you're asking?

      Delete
  9. Selcuk17 November 2014 at 21:25

    Hi thank you for your sharing. Can you help me opening old excel "xls" with your program? Or how can I open "xls" files this program?

    ReplyDelete
    Replies
    1. Anton18 November 2014 at 02:50

      Hi, no program doesn't work with .xls files. But you could try either convert your file to .xlsm or unlock file by manual method (http://lbeliarl.blogspot.hu/2012_12_01_archive.html).

      Delete
  10. Agih Cabe21 November 2014 at 06:34

    I got this error message,
    Compile error:
    The code in this project must be update for use on 64-bit system. Please review and update Declare statements and then mark them with the PtrSafe attribute.

    How to fix it?

    ReplyDelete
  11. Vernita7 December 2014 at 10:02

    Thanks so much! I have been searching for a solution fruitlessly, until I came across your template. Works perfectly!

    ReplyDelete
  12. Belajar1 January 2015 at 18:58

    Thanks It's Perfect....

    Matur Nuwun ya......

    ReplyDelete
  13. vivek8 January 2015 at 07:52

    It didn't work for me. I don't know where I am making mistake. It stops in middle and a zipped file is created. When I unzipped it, I got many folders and xml files. I don't know what to do with them?

    ReplyDelete
  14. Computechguide31 January 2015 at 03:32

    thanks to share details on removing vba passwords.

    ReplyDelete
  15. Unknown18 February 2015 at 02:33

    Hi,
    while i run VBA_Unlocker , its ask to select file and i selected the required to file. After compiling a pop up comes as " password for vba_project='macro' ".
    After i entered the password it tells invalid password.
    Plz help....

    ReplyDelete
    Replies
    1. Unknown15 November 2015 at 17:35

      Same problem here...

      Delete
    2. Unknown30 December 2015 at 05:54

      Actually for me also same issue but it will created another file with the macro password.. try to opn that

      Delete
  16. Unknown12 May 2015 at 05:26

    Superr... I often create XLSM files and had forgot the password.

    Thanks a ton for creating this

    ReplyDelete
  17. Amkagi12 May 2015 at 10:43

    This is awsome. You deserve applauds..

    ReplyDelete
  18. danty2 June 2015 at 04:33

    Great job sir thanks a lot...

    ReplyDelete
  19. klumsyboy20 August 2015 at 05:00

    not working on 64bit system, please update?

    ReplyDelete
  20. Anonymous27 August 2015 at 12:53

    You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant!
    v-travelled |

    bestofgaytravel |

    numatravels |

    travelersrvreno |

    banshitravels |

    exploreuktravel |

    alsurtravel |

    dubaitravelshop |

    couchtravels |

    hwisetravel |

    ReplyDelete
  21. Unknown28 August 2015 at 09:20

    Hmm. Not bad, I have never heard about this band. Btw I was looking for homework help online . But I've found an odd information for my future project.
    hotel-travel-america |

    selecttoursinc |

    loire-forez-tourism |

    iranadventuretours |

    travelingarmenian |

    travel-prescott |

    travelswithmaddog |

    hometownnationalwa |

    costaricasolarhomes |

    greencostaricahomes |

    ReplyDelete
  22. Anonymous28 August 2015 at 11:57

    Fantastic work and very well-written article. I will recommend reading it to all my friends
    amwayhealtheclub |

    oncarecrm |

    azheartcare |

    mfitnesslonetree |

    fourthsectorhealth |

    sandiegofitnessclub |

    liveithealthyforlife |

    greenupcountyhealth |

    boulder-vision-care |

    serenelovingcare |

    ReplyDelete
  23. Unknown30 August 2015 at 12:28

    I surprised with the analysis you made to make this particular publish incredible. Wonderful activity! 
    travelbusinessu |

    ribusiness4equality |

    marinebusiness |

    inthebusinessofhope |

    yallabusiness |

    businessforbreakfast |

    profitme |

    launchthebusiness |

    wildaboutcars |

    autocarsupdate |

    ReplyDelete
  24. Middle Ground27 October 2015 at 08:01

    worked wonderfully thank you

    ReplyDelete
  25. Unknown15 November 2015 at 17:28

    Hi Anton,
    Seems it isnt working for me...
    Can I send you my file so you can check it?
    I would be really thankful

    ReplyDelete
  26. Unknown31 December 2015 at 20:36

    This comment has been removed by the author.

    ReplyDelete
  27. Unknown1 January 2016 at 00:02

    This comment has been removed by the author.

    ReplyDelete
  28. Unknown1 January 2016 at 00:17

    Hi. Thanks for taking the time to make this into a routine. :-) I had been performing the procedure manually but had a number of xla files to do and so was looking for something to do them in batch mode. I modified your routine to do that. :-)

    Just a little issue I came across. I had some files that wouldn't load successfully as xlsm (excel wouldn't open them at all) but if they were renamed as xls then it would open them... it did however mean I needed to adjust the code in GeneralSub to ensure that the CopyFname ended in ".zip" and not just "zip"... without the ".zip" on the end the oApp.Namespace will fall over with a "Method Namespace of Object IShellDispatch5" failed error.

    So maybe you should consider making the small adjustment to your code to work on varying length file names (eg named as .xls or .xlsm). Also, to make it work on a group of files (as I did). Cheers, Warren.

    ReplyDelete
  29. Alex3 February 2016 at 03:24

    Thanks for the useful information. I used for this purpose Manyprog Excel Password Recovery. It will help restore the password to Excel file, and can recover the password to Excel sheet. http://manyprog.com/excel-password-recovery.php

    ReplyDelete
  30. Unknown6 March 2016 at 03:23

    Nice blog, keep it up in this essays have a lot of information having mostly the students are generates the best essays skills.
    Vintage Rugs

    ReplyDelete
  31. ramiz14 July 2016 at 13:35

    It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!
    microsoft excel vba training

    ReplyDelete
  32. Unknown20 July 2016 at 01:35

    This comment has been removed by the author.

    ReplyDelete
  33. harrysou6 October 2016 at 20:55

    With the help of Excel password cracker solution can unlock and crack Excel password with xls, xlsx, xltm, xla, xlm, xlam, xlsm and xlsb
    Read More: http://www.excelunlockertool.com/

    ReplyDelete
  34. Anonymous5 January 2017 at 02:58

    With this superb solution of MS Excel password breaker you can break Excel password with all versions Excel file including xlsx, xls, xlsb, xla, xlam, xltm and xlsm

    read more

    http://www.excelpasswordrecoverysoftware.excelpasswordremover.com/

    ReplyDelete
  35. sezR29 January 2017 at 05:50

    how to do for 2003 xls file password? when opened in Hex editor , didnt find DPB string

    ReplyDelete
  36. Phan Hoang Chinh31 January 2017 at 20:20

    send to me phanhoangchinh27@gmail.com

    ReplyDelete
  37. juanjuergens16 May 2017 at 07:15

    i really like this article please keep it up.
    excel courses

    ReplyDelete
  38. devilz13 November 2017 at 22:27

    Really appreciated you time and hardwork, very much grateful to you

    ReplyDelete
  39. Unknown20 March 2018 at 04:29

    Thank You Very Much for your hard work and sharing this, I was getting furious since a very long time.

    ReplyDelete
  40. Unknown7 October 2018 at 23:10

    I could not get any thing... And could not find your previous post which describe how to.. .. !!! ???

    Just frustrated

    ReplyDelete
  41. aryanoone15 May 2019 at 22:21


    Thanks for sharing such a nice Blog.I like it.
    norton activate
    norton.com/setup
    mcafee product key
    comcast support phone number
    AVG Antivirus phone number
    webroot customer service number
    kaspersky customer service Phone number
    Outlook support phone number
    microsoft edge customer support


    ReplyDelete
  42. Anonymous18 December 2019 at 13:54

    Kudos https://imgur.com/a/5Xoah1C https://imgur.com/a/3F1OjsN https://imgur.com/a/4ab5Jsg https://imgur.com/a/6TNNaZf https://imgur.com/a/wWMrKEi https://imgur.com/a/lLbfX6s https://imgur.com/a/wHVYV6z

    ReplyDelete
  43. High Technologies Solutions6 February 2020 at 23:20

    I read Your Post and really its really Nice Article & Very Informative Post Otherwise if any One Want To Grow your Career in Advanced Excel So There are Some Top Best Training Center for excel & Advanced Excel institute

    Advanced excel course in Delhi
    Advanced excel course in Noida
    Advanced excel Training in Delhi
    Advanced excel Training in Noida

    ReplyDelete
  44. reelgame.site5 January 2022 at 02:11

    Great article post.Really looking forward to read more. 파친코사이트

    ReplyDelete

Subscribe to: Post Comments (Atom)