hello and welcome back to my youtube
channel
this is Krishna today I'm gonna show you
how to unlock your own Excel workbook
and sheets which are possible protected
and you don't know the password so
remember it's a sheets and the book
books there are two levels you can lock
your worksheet and workbook and if you
forgot to passport or record a file from
somebody else and you want to unlock it
so this is the way let's see how it
works so this is a sample file and have
not saved it again and let me lock it
first so I'm gonna lock the sheet that
sheet 1 and I will say the password give
the password remember these two should
be checked and by default every cell in
action is locked ok if you want more
information check out my channel I have
a media for that taken from the past
[Music]
okay should say unprotect let me save
and come back so I have protected the
sheet and protecting the Bob Bakker
sheet 1 is protected
ok so you will not be able to change
anything though you are able to see the
content all right you cannot not
anything as the workbook is locked okay
let me save this for simplicity I am
saying it as a book 1 yep say it is
asking ok so yeah basically the she
before that they are protected now so
okay let me open this again okay go to
review see everything here is disabled
that means you're not able to edit this
file and here it is if you click it will
ask for phosphor and if you click it
will ask for possible because it is
protected so now let's see how do you
get it and you don't remember the
password it's very aside now rename this
to dot zip
okay and confirm see the format of it
the change icon change to see zip or let
it was the excel stuff okay
and one more thing if you're not able to
see the expression go to view options
change the folder options you hear this
hide the extensions for known file types
that means maybe by default it is
enabled or you have enabled it you won't
be able to see the extension that means
it will show really book one - copy the
xlsx won't be there so you have to move
enable that to change your file
extension okay now open this file
remember you're not extracting you're
opening the file okay go to excel okay
so here are using bunch of XML files the
first one you have to is the workbook
dot XML copy this so now your folder a
sphere
and this file in a notepad I'm selecting
not purpose bus okay here
search for straight protection here it
is so now this entire section is for the
protection this entire section right if
you know how to work on XML file it will
be easy for you so this the opening tag
and this is the end tag though this
should match so now you have to take out
this entire stuff okay
search for the strain protection and
identify the start and intact for this
XML tag okay so there is a way to view
this file I mean it looks better in your
pipes alright so you see here this is
the corresponding text or string or wine
you have to take out from here to here
okay let's go back to the know so this
is the protection and then I'm going to
take out this entire stuff to meet so
save as you expected it was so select
the first option okay so you have edited
the file so cross-check this now now
it's not the right the production is not
there workbook protection and is now not
there cross it let's check the file okay
so we just unlock the workbook now we
have to unlock
worksheet so now inside the zip okay
inside the zip open the Excel and then
worksheets so you will say much about
XML files so as we had two sheets so
correspondingly we have two she stirred
XML so the content for since she wanted
XML I'm gonna copy this back to my
folder anywhere outside I feel sick
okay again open this in a notepad so
notepad plus plus the school for me I'm
gonna use that he searched for the sheet
protection here it is
similarly check out the section make
sure that you only take up the
corresponding start and end time
otherwise you will lose the file yes say
make okay confirm that the changes are
effective yes I don't see the workbook
protection here justify and place this
back in Jersey hold up
Robles double check once more yep the
production is not there okay yep so here
we go see the sheet is unprotected the
workbook is unprotected you can add any
number of sheets and you can edit the
content as well thanks for watching do
subscribe to my channel and check out my
channel for more useful videos on office
automation thanks and see you later