Aug 08 2020 04:10 AM - last edited on Nov 09 2023 11:08 AM by
Hi team need support to unprotect my sheet which is password protected and forgot the password
Oct 24 2021 08:48 PM
Oct 25 2021 01:41 AM
I don't have a Mac and have never tried it, but it should work exactly the same way in the VBA method. Only the paste commands change, for example on the PC I use Ctrl + C to copy and on the Mac Command + C.
There is actually no difference in VBA itself .... in my humble opinion.
But I always like to be taught better.
Anyway, be at your disposal.
Nov 18 2021 12:41 AM
Nov 18 2021 06:58 AM
Hello - read your message about the copy / paste function to a new tab, which is great. I had formula's in there because I have a 2 tab document I use. Anyway that the formula's will copy over? When I completed the copy/paste they didn't show up. Wondering if there is a work around. Thanks!
Nov 23 2021 08:36 PM
@NikolinoDE What do i do with the code? could you explain it to me like a kid.
Nov 23 2021 10:33 PM
In this link you will find instructions with pictures and step-by-step explanations.
VBA Code to Unlock a Locked Excel Sheet
Furthermore, I wish you much success with Excel.
Nov 25 2021 09:45 AM
@NikolinoDE Hey hi i did follow the same step you specify to the guy at the begginings of this converation it wont work, wuold you help me out if i give you the file, i desperately need it
Nov 29 2021 05:52 AM
@NikolinoDE Is there any way you can remove the password for this workbook for me. I created it at work with a team and the employee who pass worded it is no longer employed by us and we need access. Appreciate it
DJP
Nov 29 2021 11:32 AM
@Edruolp AccentEPR instantly removes such password protection set for Excel 2016+. It was possible to instantly find a collision for ealier versions of Excel. As for later versions of Excel, only removal can help. But still instantly.
Please note: it works only for the protection against accidental changes. It is impossible to find the password for encryption (Password to Open) instantly. Only if it refers to really old Office 6-95 ;p
Nov 30 2021 04:56 PM
@NikolinoDE I tried your link, but my file is password protected, not just the sheet. So, when I open it it pops up a small dialogue box for a password and no matter what I try I can't open anything else. Ideas? It is just a Christmas gift spreadsheet so the kids didn't see so nothing secret. If you can help and open it, please let me know what I need to do. thanks
Dec 10 2021 09:52 AM
@NikolinoDE I have also locked myself out of my sheet. Would you be willing to let me send mine to you to be unlocked as well? I tried running your code and let it run for an hour or so, but I stopped it.
Dec 13 2021 06:56 PM
Dec 13 2021 06:57 PM
Dec 20 2021 04:49 PM
With my protected workbook this won't work.
When click Alt +F11 and double click on the file the pop up box asking for my password appears so I can't proceed
Dec 24 2021 11:59 PM
Jan 06 2022 02:03 AM
You have a 88% chance of unprotecting your Excel password. Excel's password protection is not very secure (I've cracked open in a few hours).
You can do either of the one.
Do let me know if it help.
Jan 06 2022 02:19 AM
Many thanks but NikolinoDE managed to find it for me which was so helpful. Thanks anyway.
Jan 08 2022 12:58 PM
@Damo_S This didn't work for me, when I .zip the folder and try to open it comes with an error and won't show me any files. I've tried from Mac and Windows, none of them worked.
Jan 11 2022 06:10 PM
Jan 12 2022 06:24 AM
Hello @NikolinoDE , I would like to send you over 2 files to which I lost password. I just came back from a long break holidays. This is about sensitive informations so I am really looking forward to your non-disclosure agreement while helping. Could you please assist? Many Thanks in advance!