00:00If you have ever locked your worksheet and forgot your password, this is how you can unlock it
00:04without the password. But before I show you how you can unlock without the password, let me show
00:09you how you can lock the worksheet. First, you're going to go to review on the ribbon and after go
00:15protect, protect sheet. And I'm going to protect the rota sheet with a password called ABC and
00:22click OK. They will ask you to re-enter the password again, ABC, click OK. Now I'm going
00:27to press Ctrl S to save the workbook and close my workbook here. Now if I were to reopen my
00:33workbook
00:34one more time and try to edit any cell on this rota sheet, it will tell me that the sheet
00:40is
00:40password protected. Now at this instance, if you have forgotten the password, it's difficult to work
00:45with. So let me show you how this is done. The first thing you're going to have to do is
00:49to take a note
00:50of the sheet number here. The very first sheet on your workbook is called rota and this is the one
00:56that has been locked. This is called sheet one, this is called sheet two and sheet three. For some
01:01reason, if you were to move rota somewhere around here, now rota is called sheet three. Just remember
01:07that. But there's a lot of misconception on the internet saying that you can actually differentiate
01:12using the VBA code editor. Let me show you what I mean by that. If you right click your rota
01:17and go view
01:18code, rota is identified as sheet two here. So that's not the case when you actually work with the
01:25XLS internal file. So I'll show you that file shortly here. So rota for this purpose is called sheet one.
01:34So let me close this guy here and save it. So on the file level on your Windows File Explorer,
01:42you're going to change the file extension from XLS to zip. You're going to press F2 and change it like
01:51that. And then Windows will prompt you saying that your file extension is about to change. So say yes,
01:56and the icons will change. Now what you're going to do is you open up the zip file, go to
02:01Excel,
02:03worksheet, and this is what I mean. This is where the road meets the road, I guess the rota will
02:09be
02:09sheet one, not sheet two as what the VBA editor has duplicated. So with that, you're going to have to
02:16copy this to a separate folder in your Windows, you can't really make edits on the zip file. And then
02:23after that, you're going to open any text editor, I'm going to open a text editor called say notepad,
02:29which everyone has. And then I'm going to move this into my notepad here. Over here, you're going to
02:36press Ctrl F and search for a text called sheet protection like this. And then you should be able
02:42to find the parameters or the XML elements called sheet protection. You're going to highlight this
02:49all the way down to scenario one equal to double quote one double quote four slash greater than sign.
02:57Make sure you put the greater than sign here as well. Once that's done, press delete on a keyboard to
03:02delete the complete XML element for sheet protection. After that, you're going to go and save the file
03:09file on your notepad. And basically close your notepad like that. And then this is the edited file. And now
03:17you're going to have to move this file back to the zip file by clicking and dragging back to its
03:23original
03:23position. And Windows will prompt you saying that you're about to replace it because there's sheet one
03:29already in there. You're going to say copy and replace and that get replaced. Let's go back to our
03:35original file or the folder where our file was. And now we're going to reverse the process. Press F2
03:42and then change the file name extension from zip to xlsx. And hit enter. And again, Windows will prompt
03:51you saying that your file name extension is about to change. Over here, you're going to click yes. And
03:56then the icons will change to Excel now. Now if you were to open your workbook and go to your
04:02Rota worksheet,
04:03now in here, you can make changes to the worksheet, which means that this worksheet is unprotected or
04:11unlocked once more.
Comments