[Music]
thank you
welcome back to another episode of
Microsoft Excel today in this video I
have my Excel workbook here and I have
forgotten the worksheet password
completely I have tried to unprotect it
but I don't remember so it's a bit
tricky but very simple you don't need to
spend any money on this or absolutely
it's a very legit way you can to unlock
your own workbook so what you're gonna
do is make a copy of this avoid any
errors right click on it and make a copy
so I have made a copy here you must
remove everything here so I have the
copy or you know you see it I'm going to
modify this original so what you're
going to do now first is right click on
this and rename it so after renaming
you're going to click change this to Z
but in case you're not able to see the
file extensions you need to open any
folder from your desktop and once you
open it come to view and you'll be able
to see file extension here so if you
click on it you uncheck you you will not
be able to see the extension so what you
do you need to view and make sure it is
checked so once you that you can close
and you come back to your file so now
I'm going to rename this call it as zip
okay
so it pops up some small money but just
say yes so it's now a zip file what you
want to do now is you're going to
extract this ZIP and you can extract
within the desktop yes now this is our
file that we have extracted it's
actually here this dentex ZIP this is
Bendix so you're going to open that and
you'll be able to say about four files
in it so what you want to do is open
this third one called XL
once you open it we're going to deal
with worksheets remember when you open
your file let me open from here which
worksheet was protected so this is my
first worksheet which is here so meaning
I'm going to deal with this menu here
other worksheets are probably open if
you look up they are actually open but
this first one is the one which is
locked so I'm going to close this so now
I'm going to open this worksheets so you
realize it is worksheet one that is log
so what you do is close this come to
this book open these four files open
worksheets and right click on this
worksheet one and open with any text
editor you have in your PC me I am going
to use the default which is notepad from
here you're going to Ctrl F to search
for a simple chord so going to Ctrl F
then you press protection then you say
fine you can see it's here but in case
it doesn't show you keep playing around
this it pops up like not 5
playing around that so but in my case I
have already found it so you can see you
have to remove from where this opens and
closes so thumbs up to here once you've
seen it like this you're going to
backspace or delete all this like that
once you finish that you can just go
ahead and close this and save it once
you've finished you're going to close
everything open that folder and
highlight all these four files right
click on it and zip it again or send to
compress folder so you're going to
compress and you give it a name of your
choice for the example then text no
password press enter so as you can see
it's now like this I'm going to move it
to the desktop as well let it be here
I'm going to follow this
so from here you just go and right click
on it
and remove the zip and put back XL SM
[Music]
then you press and once you finish that
say yes and by the time you open now you
can see if you go to review there is no
more password and I cannot I can be able
to edit all this so in case you want to
remove for the workbook check up the
video on the top I've already recorded
that or you also want to remove password
for the VBA I will obviously also check
top of the video thank you very much bye