Mar 23 2020 11:14 AM
I have a password protected worksheet that I do not remember the password for. How do I unprotect the sheet for editing?
Mar 24 2020 04:50 AM
SolutionMar 24 2020 06:07 AM
@Savia ,
Thank you for the advice, however, I decided to make a copy of my original file to prevent against losing anything before I attempted to do it on my own. After a search query related to the subject, I found that I was able to work through a help screen to find a solution that actually worked. I found a site that spoke about using a VBA code to unlock the password.
It walked me through the steps fairly easily and I was able to copy the code right from the screen as instructed and paste it onto my own screen. After running the code (I needed to do this a couple of times because I wasn't sure how to actually run the code on my computer at first) it actually provided me with a temporary unlock password, AAAAAAAAAA, which I used, and was actually impressed that it worked.
I have since protected the sheet again and this time chose a unique password. To remember it, I have typed in a hint outside of the spreadsheet that will help me next time I need to unlock the spreadsheet to update it (eg. my favorite teacher in high school).
Thanks again,
Dave Diesel
May 11 2020 05:48 AM
Dear all
since i can' find an easy solution do i need to copy-paste my previous excel worksheet and create a new one (unprotected)?
thanks
May 11 2020 06:00 AM
You cannot open a password protected sheet without pasting in the password.
There are tools that force open a sheet but they are not reliable to be used on your device.
Unfortunately, you shall have to remember the password.
Regards.
Admin
May 11 2020 06:14 AM
Hi my issue is similar to previous one, but I know I haven't password protected a sheet, how do I unprotect it when its asking for password, to which I haven't got or ever had....
Mar 24 2020 04:50 AM
Solution