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?
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
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.
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?
Thank you 👍🏼
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
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?
Hi brother, in the first step, can we change the password ? many thanks
Good video
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
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 - czcams.com/video/oq59u0rpkiE/video.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/
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?