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
Sep 19 2022 10:48 AM
@NikolinoDE The code ran okay. I received the "Finished" message box, but the active sheet was still locked. I do not understand how the code can work when 10 characters cycle between A and B and only the last character cycles between all of the keyboard characters.
Thank you,
Andy
Sep 23 2022 10:53 AM - edited Sep 26 2022 12:59 AM
This worked for me: unzipping file, removing sheetProtection XML tags from the sheetN.xml files and zipping files again, as per Damo_S post.
Unfortunately, the VBA code approach completed but didn't succeed in unprotecting the sheet.
Sep 24 2022 10:14 AM
@Deleted Try this. Save the workbook as an Excel 97-2003 Workbook and then run the code. That worked for me.
Andy
Oct 03 2022 12:49 PM
Old thread: hoping someone sees this. I have run this macro, but keep getting Compile Error, Syntax Erro on the following: .Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & _
I've got a workbook with multiple locked cells, and the person with the p/w lives on Sanibel Island... and I'm trying to finish our budget.
Thanks!
david
Oct 03 2022 01:12 PM
Oct 03 2022 02:02 PM
Thanks, Andy. Caught that right after I posted. Ran, but no results - never got the Finished, message, though. I also noticed the Protection uses SHA-512 and not AES-128, so perhaps not going to give an answer? Weird part is task manager shows almost zero CPU usage. Not sure what is going on.
thanks,
David
Oct 03 2022 05:57 PM
Oct 03 2022 06:15 PM
Hey Andy,
Thanks. Yes, I saved it as a xls (97-2003) file first. That is why I am flummoxed. It should at least push the Finished msg box or fail. It just stays silent.
thanks/David
Oct 04 2022 08:35 AM
I just came across this code today. One additional question. I have a password on the workbook and have a tab hidden. I need to update the lists on that hidden tab for my data validation drop down lists. I have opened the page with the data validation, but I cannot access the back-up list.
Is there a version of this code that removes the password from the entire workbook?
Thank you in advance for your assistance.
Christina
Oct 04 2022 09:18 AM
Oct 10 2022 08:32 AM
I have the same problem
I could not attach the file you can help me remove the password protection on the cells. I can email you the file.
My email is email address removed for privacy reasons
Oct 14 2022 04:26 PM
@NikolinoDE I just tried this on my iMac. I thought it was going to work, but I got a syntax error message. Do you know if the code would be different for the Mac OS? Thank you!
Oct 14 2022 06:23 PM
Oct 20 2022 08:50 PM
@NikolinoDE It has done the miracle. Thanks
Oct 26 2022 07:34 AM
Oct 26 2022 06:00 PM
Oct 29 2022 03:25 AM
@NikolinoDE You are remarkable. This worked for me. Phew! Only took a few seconds. Thanks!
Nov 05 2022 06:06 PM
@NikolinoDE could you please help me with this? I don’t see what to the right was to be copied and pasted. I have an excel chart that’s about 3 years old I just found and needed some info off of it; but I can’t remember the password for it. any other tips would be appreciated! For full disclosure I’m not a developer or IT expert by any stretch of the imagination.
Nov 07 2022 04:11 PM
Funny loophole if you have a Mac. Open the file in Numbers which will strip the protection, then export back to Excel.
Nov 07 2022 05:02 PM