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
Hi
ReplyDeleteIt dont work with .Xlsm files, I have checked it two files, error message when you Debug is: tmpWB=Nothing
Hi,
Deleteit 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)?
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.
DeleteIn 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.
DeleteTool link: http://www.vbapasswordremover.org/
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.
ReplyDeleteMine English either :). I'm glad that it helped you.
DeleteHi Anton,
ReplyDeleteI could successfully do it once. But every subsequent attempt on same file, i got error message "File don't have VbaProject!"
pls help!!
Hi,
DeleteTry 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.
not work
DeleteWonderful, worked like a charm.
ReplyDeleteThanks!
Please send me ur id so that I can send u the file.
ReplyDeleteMy id is niladri.biswas2005@gmail.com
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
ReplyDeleteI 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.
DeletePlease send me ur id so that I can send u the file.
ReplyDeleteMy id is willywahyu46@gmail.com
Your program is wonderful.
ReplyDeleteThere 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?
I'm sorry, but didn't understand your question; about what message you're asking?
DeleteHi 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?
ReplyDeleteHi, 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).
DeleteI got this error message,
ReplyDeleteCompile 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?
Thanks so much! I have been searching for a solution fruitlessly, until I came across your template. Works perfectly!
ReplyDeleteThanks It's Perfect....
ReplyDeleteMatur Nuwun ya......
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?
ReplyDeletethanks to share details on removing vba passwords.
ReplyDeleteHi,
ReplyDeletewhile 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....
Same problem here...
DeleteActually for me also same issue but it will created another file with the macro password.. try to opn that
DeleteSuperr... I often create XLSM files and had forgot the password.
ReplyDeleteThanks a ton for creating this
This is awsome. You deserve applauds..
ReplyDeleteGreat job sir thanks a lot...
ReplyDeletenot working on 64bit system, please update?
ReplyDeleteYou know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant!
ReplyDeletev-travelled |
bestofgaytravel |
numatravels |
travelersrvreno |
banshitravels |
exploreuktravel |
alsurtravel |
dubaitravelshop |
couchtravels |
hwisetravel |
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.
ReplyDeletehotel-travel-america |
selecttoursinc |
loire-forez-tourism |
iranadventuretours |
travelingarmenian |
travel-prescott |
travelswithmaddog |
hometownnationalwa |
costaricasolarhomes |
greencostaricahomes |
Fantastic work and very well-written article. I will recommend reading it to all my friends
ReplyDeleteamwayhealtheclub |
oncarecrm |
azheartcare |
mfitnesslonetree |
fourthsectorhealth |
sandiegofitnessclub |
liveithealthyforlife |
greenupcountyhealth |
boulder-vision-care |
serenelovingcare |
I surprised with the analysis you made to make this particular publish incredible. Wonderful activity!
ReplyDeletetravelbusinessu |
ribusiness4equality |
marinebusiness |
inthebusinessofhope |
yallabusiness |
businessforbreakfast |
profitme |
launchthebusiness |
wildaboutcars |
autocarsupdate |
worked wonderfully thank you
ReplyDeleteHi Anton,
ReplyDeleteSeems it isnt working for me...
Can I send you my file so you can check it?
I would be really thankful
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi. 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. :-)
ReplyDeleteJust 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.
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
ReplyDeleteNice blog, keep it up in this essays have a lot of information having mostly the students are generates the best essays skills.
ReplyDeleteVintage Rugs
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!
ReplyDeletemicrosoft excel vba training
This comment has been removed by the author.
ReplyDeleteWith the help of Excel password cracker solution can unlock and crack Excel password with xls, xlsx, xltm, xla, xlm, xlam, xlsm and xlsb
ReplyDeleteRead More: http://www.excelunlockertool.com/
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
ReplyDeleteread more
http://www.excelpasswordrecoverysoftware.excelpasswordremover.com/
how to do for 2003 xls file password? when opened in Hex editor , didnt find DPB string
ReplyDeletesend to me phanhoangchinh27@gmail.com
ReplyDeletei really like this article please keep it up.
ReplyDeleteexcel courses
Really appreciated you time and hardwork, very much grateful to you
ReplyDeleteThank You Very Much for your hard work and sharing this, I was getting furious since a very long time.
ReplyDeleteI could not get any thing... And could not find your previous post which describe how to.. .. !!! ???
ReplyDeleteJust frustrated
ReplyDeleteThanks 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
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
ReplyDeleteI 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
ReplyDeleteAdvanced excel course in Delhi
Advanced excel course in Noida
Advanced excel Training in Delhi
Advanced excel Training in Noida
Great article post.Really looking forward to read more. 파친코사이트
ReplyDelete