🔓 Remove VBA Password in Seconds in Excel (2 Easy Ways)

[@DragoșRadu-m9f]

Sir, I really don't know how to thank you (and Mr. Su Tom) for providing this helpful video to me. I was about to create the code blocked by the VBA forgotten password and that would have been a very painful process, especially now at 03:00 AM in the morning. Thank you so much.

[@trumpexcel]

Glad the video helped 🙂

[@steward01]

Perfect, tried and failed doing it myself from SO instructions, much easier to follow along. Turns out not only had I forgotten the passwords from my project but also everything else I taught myself about VBA all those years ago.

[@IvanCortinas_ES]

Excellent tutorial. Thank you for sharing it, Sumit!!!

[@trumpexcel]

Thanks Ivan 🙂

[@temyraverdana6421]

Wow, amazing. Thanks a lot for share it

[@josedanielsolis2833]

Amazing, worked first time, thanks a lot.

[@prakash180]

Hi Sumit, Your videos are very helpful to me. Thank you so much. What are the additional protection methods for excel & VBA in such a way that we cant use these ways to unprotect?

[@Satwant2463]

Thank you 👍🏼

[@SenseiTrades]

what about when vb editor says project is unviewable and doesnt give option to type a password

[@singarajamudhaliar3736]

Thank you So much, I have recovered 3 years old file. Once again thank you.

[@bobbriggs4287]

Neither of these worked for me. I was able to correct the declare sub and function statements by inserting PtrSafe but got a type mismatch error for VarPtr. I don't know how to fix this. The hex editor method has never worked for me. Even when I replace the DPB with DPX (or whatever it was) it did not unlock.

[@vishytheking]

i have a xlsm file which is locked. in your example you are showing that your file is showing in the VB screen and you are opening a new file to copy paste the code. so the locked file is open in the background and when this code is run its unlocking.. second is, without a file open, i could not insert a module to paste the code. may be you know a round about.. thanks i am on excel 365

[@keepsecret7624]

I much prefer a written tutorial to such videos. Videos do have a use, but the best results are written + Video.

[@trumpexcel]

Here you go - trumpexcel.com/excel-vba/remove-password/

[@Live_for_Learn_everyday]

sir "Project is unviewable" ko unblock karne ke liya kya karna hoga ?

[@dhirajm85]

Good video

[@AnjanBasumatary]

Im able to unlock the protected xlsm excel sheet...but the excel has validity, how to change that?....ALSO ONE folder is showing project is unviewable instead of asking for password

[@contabilidadmasexcel6104]

Eres Genial!!!!

[@krismj24]

Do you have any solution for MacOs?

[@akalarun]

I have password to open the Excel file. Now I forgot that password to open the Excel file. Is it possible to recover that password?

[@celyb8384]

I have a question, have an excel sheet, no VBA project but I input password. Now I can't remember the password and I can't open the excel sheet. What should I do?

[@trumpexcel]

This might help - kzbin.info/www/bejne/paKYaqhmp9Wen6c

[@mr.google6086]

sorry to say this but excel locks the file but not encrypts it so the easiest way to unlock is by opening the file using another software like open office. Many people think hiding the code ie making it unviewable is a secure method but even that doesn't work out if you are using a software other than Excel i believe soon micro soft will take some action for this

[@trumpexcel]

True, opening Excel in another applications would easily bypass any security such as VBA locking. But that sometimes also leads to loss in functionality as Excel has a lot more feature than others

[@derekporter66]

Why would they make it such low security

[@trumpexcel]

Yeah, it's pretty easy to break and anyone with a little bit of research can do it. Hence, the advice to not rely on Excel's in-built security only

[@حسنعلي-ظ4م4خ]

Hi brother, in the first step, can we change the password ? many thanks

[@shamilvakkaloor3183]

How to unlock VBA in the PPt?

[@Hill_null]

The first one didn't work because I'm on a Mac. The second one also didn't work either.

[@idrissoumoussa6705]

this does not work with ms access

[@ahmedmonhem]

THANKS

[@IvyPlans]

Is there a way to not allow the VBA not to be unlocked? People lock files for a reason. 👎🏻

[@trumpexcel]

I don't think there is anything built in Excel to be more secure. For people selling Excel files or templates, one idea could be to have it before a paywall and only gives access to those who buy, and then lock the VBA as well. Again, doesn't guarantee full security. There might be some third party tools to lock Excel, but I will have to do some research to find some.

[@IvyPlans]

@@trumpexcel There is a third party app, but you have to pay extra.

[@brianforbes3012]

You should not be showing this. Developers who have spent months programming and trying to protect their creation, you destroy it in 8:57 sec.

[@trumpexcel]

I believe it's better for people to know that Excel's in-built security is pretty weak and to use better ways to protect their work. And this is useful for many people who genuinely need help and are not trying to rip off other people's work.

[@IvyPlans]

I totally agree.

[@IvyPlans]

@@trumpexcel People will use this to rip other peoples work. Especially if you sell digital products.

[@akalarun]

I have password to open the Excel file. Now I forgot that password to open the Excel file. Is it possible to recover that password?

[@ventjemazzel8822]

👍