How to unlock protected Excel VBA Project Method 2

preview_player
Показать описание


Have you forgotten the password of your VBA aka 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 have only one sheet and contain 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 a 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 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.

This method helps you to unlock VBA project password without a hex editor

FAQs

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 a lot of sheets?
Yes.

6)Will it unlock if my workbook contains Userform, Class Modules?
Yes.

If you have any doubts just contact me through the link given below

********** Tutorial Playlists **********

****** Contact me ********

******* Books written by me ********

******* Productivity tool *********

******* Gear Used To Shoot This Video ******
_Audio & Microphone

********Learning partner********

Рекомендации по теме
Комментарии
Автор

do you still have this i VBA password unlocker

mogannaidoo
Автор

Hello Amarindaz, i open the file unlocker but i get a "The code in this proyect must be updated for use on 64-bit systems. Please review and update declare statements and then mark them with the PtrSafe attribute" What i can fix that in order to use your system?

millenniummortgagecorp.
Автор

I did a purchase today but looks like it is still not compatible with 64 bit, so at this point it is not of any use to me. could you please check and let me know.

rsugandhan
Автор

Will it work if my project is .xla? cause I tried your first method and the .xla project didn't work but it works for .xlam

misheelpatel
Автор

you would have lead on with it is for purchase

marceljunioregondi
Автор

terima kasih bosku, from Indonesia great 👍👍👍

jackseparow