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.
Perfect, saved me - I had written a really nice by very complicated workbook to generated some docs - I did this about 4 years ago and since then haven't touched it and couldn't remember the PW... I had tried the DPM > DPx method, but that doesn't work on x64. This VBA macro method worked a treat first time - HUGE thanks for sharing 👍👍👍👍
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.
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?
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.
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
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
To prevent the first attack, link the code/project too a license and this will stop the code on a separate workbook from opening the in house license/project. Too stop the second attack use a large password of 30 charters and this will prevent HxD from deciphering the remaining digits 123. This worked for me in Excel 2024 home edition. Both attacks failed. I will be keeping an eye on this comment and other similar TH-cam videos to prevent copyright theft.
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?
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
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
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.
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.
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.
Perfect, saved me - I had written a really nice by very complicated workbook to generated some docs - I did this about 4 years ago and since then haven't touched it and couldn't remember the PW... I had tried the DPM > DPx method, but that doesn't work on x64. This VBA macro method worked a treat first time - HUGE thanks for sharing 👍👍👍👍
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.
Glad the video helped 🙂
Excellent tutorial. Thank you for sharing it, Sumit!!!
Thanks Ivan 🙂
Wow, amazing. Thanks a lot for share it
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?
Amazing, worked first time, thanks a lot.
Thank you 👍🏼
Thank you so much
Thank you So much, I have recovered 3 years old file.
Once again thank you.
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.
what about when vb editor says project is unviewable and doesnt give option to type a password
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
Do you have any solution for MacOs?
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
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?
Please can i send my excel to you so that you cna help me i have failed
Hi brother, in the first step, can we change the password ? many thanks
sir "Project is unviewable" ko unblock karne ke liya kya karna hoga ?
Good video
Eres Genial!!!!
To prevent the first attack, link the code/project too a license and this will stop the code on a separate workbook from opening the in house license/project. Too stop the second attack use a large password of 30 charters and this will prevent HxD from deciphering the remaining digits 123. This worked for me in Excel 2024 home edition. Both attacks failed. I will be keeping an eye on this comment and other similar TH-cam videos to prevent copyright theft.
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?
This might help - th-cam.com/video/oq59u0rpkiE/w-d-xo.html
I much prefer a written tutorial to such videos. Videos do have a use, but the best results are written + Video.
Here you go - trumpexcel.com/excel-vba/remove-password/
THANKS
How to unlock VBA in the PPt?
Why would they make it such low security
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
this does not work with ms access
The first one didn't work because I'm on a Mac. The second one also didn't work either.
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
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
Is there a way to not allow the VBA not to be unlocked? People lock files for a reason. 👎🏻
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.
@@trumpexcel There is a third party app, but you have to pay extra.
👍
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.
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.
I totally agree.
@@trumpexcel People will use this to rip other peoples work. Especially if you sell digital products.
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?
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA)): error