1
00:00:01,460 --> 00:00:07,190
In this lecture, we are going to see how we can remove seed and viable protection from actual seeds.

2
00:00:08,500 --> 00:00:13,480
In the previous lectures, we have seen how we can correct Excel file passwords and how we can remove

3
00:00:13,480 --> 00:00:14,830
the read only section.

4
00:00:15,940 --> 00:00:21,940
In this lecture we are going to see how we can remove the protection from Excel sheets and the workbook

5
00:00:21,940 --> 00:00:22,750
protection.

6
00:00:25,870 --> 00:00:28,900
Let's first see how we can remove seat protection.

7
00:00:30,990 --> 00:00:34,020
You can protect a sheet from the review tab in Excel.

8
00:00:34,050 --> 00:00:37,110
A protected shield limits any modification in the sheet.

9
00:00:37,770 --> 00:00:41,130
Go to the View tab and then select the option to protect, cheat.

10
00:00:41,460 --> 00:00:42,540
Give it a password.

11
00:00:44,190 --> 00:00:46,170
No change the file extension to zip.

12
00:00:48,620 --> 00:00:51,680
Open the Z folder in Windows Explorer or Winrar.

13
00:00:54,380 --> 00:00:59,540
Look for the sheet file in the worksheet folder and open it in the text editor.

14
00:01:02,730 --> 00:01:07,810
Research for the content, sheet protection and above all contents within the given tags.

15
00:01:13,550 --> 00:01:18,860
Save the file separately with the same name and then drag it to the actual archive and replace the original

16
00:01:18,860 --> 00:01:19,370
file.

17
00:01:22,930 --> 00:01:28,240
No change back to file extension to excel file and your sheet protection will be removed.

18
00:01:32,110 --> 00:01:32,470
No.

19
00:01:32,470 --> 00:01:35,050
Let's see how we can remove the protection.

20
00:01:37,280 --> 00:01:40,520
You can protect a workbook from the review tab in Excel.

21
00:01:40,590 --> 00:01:44,300
Updated Workbook limits any modification in the sheet structure.

22
00:01:46,020 --> 00:01:50,580
You cannot add or delete shoes, you cannot hide or unhide shades.

23
00:01:51,030 --> 00:01:54,360
Go to the view tab and then select the option to protect the book.

24
00:01:54,390 --> 00:01:55,410
Give it a password.

25
00:02:00,850 --> 00:02:02,410
Jane, the file extension does a.

26
00:02:09,139 --> 00:02:11,780
Open the Z folder in Windows Explorer or Winrar.

27
00:02:17,640 --> 00:02:22,200
Look for the workbook doc xml file indexer folder and open it in a text editor.

28
00:02:25,140 --> 00:02:29,850
Search for the content vegetable protection and remove all the contents within the tags.

29
00:02:30,950 --> 00:02:35,510
They'll save the file separately with the same name and then drag it to the actual archive and replace

30
00:02:35,510 --> 00:02:36,470
the original file.

31
00:02:38,200 --> 00:02:42,160
No change Back to file extension and your sheet protection will be removed.

32
00:02:43,940 --> 00:02:44,300
No.

33
00:02:44,300 --> 00:02:45,110
Let's see that.

34
00:02:45,110 --> 00:02:46,220
Your demonstration.

35
00:02:49,150 --> 00:02:52,570
First of all, create a new shoot and write something in it.

36
00:02:53,800 --> 00:02:56,620
We'll go to review tab and click Protect Sheet.

37
00:03:00,750 --> 00:03:01,850
I gave it a password.

38
00:03:07,420 --> 00:03:08,620
Most of the file.

39
00:03:11,970 --> 00:03:14,580
Ensure that you saved in XLS format.

40
00:03:17,090 --> 00:03:19,760
Now to check whether our sheet has been protected.

41
00:03:19,970 --> 00:03:24,080
Open the file and you can see that the shooters logged.

42
00:03:30,900 --> 00:03:32,830
Well, Jane, the fight extension zip.

43
00:03:37,980 --> 00:03:38,550
No right.

44
00:03:38,550 --> 00:03:41,250
Click it and open it with Windows Explorer.

45
00:03:43,810 --> 00:03:45,220
Go to Excel folder.

46
00:03:46,710 --> 00:03:50,870
This huge folder and you can see a file sheet XML.

47
00:03:52,370 --> 00:03:52,620
No.

48
00:03:52,640 --> 00:03:54,380
Drag this file to the desktop.

49
00:03:56,130 --> 00:03:57,570
Open it with a text editor.

50
00:04:02,950 --> 00:04:04,470
So I shoot production.

51
00:04:11,320 --> 00:04:14,530
Remove all the content between sheet protection tax.

52
00:04:20,470 --> 00:04:21,459
Save the file.

53
00:04:24,510 --> 00:04:26,520
And drag the file to the original folder.

54
00:04:32,440 --> 00:04:34,360
The file extension to extend file.

55
00:04:36,820 --> 00:04:40,210
Open it and you can see that she put the remote.

56
00:04:46,790 --> 00:04:49,160
Logo activate the workbook protection.

57
00:04:50,780 --> 00:04:55,760
You can go to the review tab and select the protection and give it a password.

58
00:04:59,900 --> 00:05:00,710
We'll save it.

59
00:05:02,340 --> 00:05:05,910
Once you open it, you will see that you cannot add or delete and shoot.

60
00:05:06,330 --> 00:05:09,000
You cannot also hide or hide any shoot.

61
00:05:12,900 --> 00:05:13,880
Close the file.

62
00:05:17,110 --> 00:05:18,690
Jane Doe extension back to the.

63
00:05:21,280 --> 00:05:22,960
Open it with Windows Explorer.

64
00:05:28,100 --> 00:05:29,450
Go to Excel folder.

65
00:05:30,290 --> 00:05:32,840
And here we have got a XML file.

66
00:05:33,770 --> 00:05:35,270
Drag the file to the desktop.

67
00:05:36,820 --> 00:05:38,680
I look for protection.

68
00:05:41,870 --> 00:05:42,000
No.

69
00:05:42,080 --> 00:05:45,380
Remove all the content between workbook production tags.

70
00:05:47,560 --> 00:05:48,310
Save it.

71
00:05:50,250 --> 00:05:51,900
Drag the file to the original folder.

72
00:05:55,670 --> 00:05:57,740
Login to file extension back to Excel.

73
00:06:01,380 --> 00:06:02,110
Nobody.

74
00:06:06,780 --> 00:06:09,750
And you can see that our protection has been removed.

75
00:06:15,260 --> 00:06:18,320
I hope you like this lecture and see you in the next lecture.

