Excel VBA Project Unlocker tool
Note: You must use this on Win 32 bit machine
Have you forgot the password of your VBA(Macro) Project? Want to unlock it?
Let's see how to unlock protected Excel VBA project using VBA Unlocker tool.
But before move on to the steps, I just want to ensure that it won't unlock protected excel sheets or protected excel workbook
To Unlock protected excel sheets check out->
Let's see the steps to unlock vba project password
1) First open the file unlocker sheet that you have downloaded here
2) Make sure that all other applications in the window are closed(It improves the unlocking speed)
3) Now the VBA unlocker has only one sheet and contain a button unlock
4)Click on the button and it'll ask you to select the file in the dialog box
5)Go to the path where you have the protected VBA workbook and select it and click OK
6)It'll take few seconds to one minute to unlock
7) Once your VBA project is successfully unlocked, you'll get a confirmation pop up on the screen
8)Now go to the unprotected workbook developer tab, Tools - >VBA Project - Project properties
9)Uncheck the "Lock project for viewing" and click on OK. Save the VBA tab and close it.
10) Now go to the Unprotected workbook. File- Save As. Save it as a new file somewhere on your PC.
11)That's it. Now your workbook is successfully unlocked.
FAQ
1)Will it unlock any VBA project?
Yes. It'll unlock any VBA project protected with the password.
2)What will I do if my Excel got crashed during unlocking?
Close the Excel and close other applications opened on your windows and repeat the steps.
3)Will it unlock excel sheets?
No
4)Will it unlock excel workbook?
No. It'll only unlock Excel VBA project protected with the password.
5)Will it unlock if my workbook contains lot of sheets?
Yes.
6)Will it unlock if my workbook contains Userform, Class Modules?
Yes.
7) What type of OS this work?
Please ensure that it works only on Win32 OS. It won't work on any other operating system.