hello friends welcome to DB tutorials
you might have seen how to unprotect an
excel sheet using VBA code in our
previous tutorial but in this tutorial
I'm going to show you how to unprotect
excel sheet without password and without
any code before starting the process we
need to enable the extension named
display option for all the files in our
system go to any folder and from this
quick access toolbar go to this view and
take this file name extensions ok so
this option you will be getting in
Windows 10 if you are using Windows 7 or
any lower version you need to go to
organize and click on folder and search
options now once this is done let us
create an EXO shi'ite in this folder and
let us open it add some sample entries
and protect this sheet like this okay
you can check that this sheet is now
protected then close this sheet and now
let us see how to unprotect this sheet
now going to this same folder containing
the Excel workbook select the workbook
right-click and select the rhenium
option change the extension name from
dot xlsx to dot Z okay now double-click
the zip file to open it now here click
on this Excel folder and then click on
the worksheets folder here you will see
one sheet with XML format sheet 1 dot
XML is our protected sheet right-click
on the sheet and click on extract to
extract this file to the folder now go
back to the folder
right click on this extracted sheet that
is sheet 1 dot XML and open this with
not bad
now here search for the word protection
and remove this particular protection
word from this notepad and save this and
close now select this sheet 1 dot XML
and drag this sheet into the zip file
click OK to add this to the zip file and
close the zip file now
now finally rename this zip file back to
dot xlsx and click on yes ok
open the file excel file and now you can
see that the sheet has been unprotected
successfully you can enter any value in
any cell in this sheet now I believe
this trick would be really amazing right
I hope you have enjoyed this tutorial if
yes please do give me a like share and
comment for further more interesting
videos please do subscribe T P tutorials
Thank You friends thanks for watching
[Music]