1
00:00:00,810 --> 00:00:07,060
Hello and welcome back to another class of our course about the complete introduction to accept the

2
00:00:07,810 --> 00:00:13,950
I'm so into this class, we are going through what we're still talking about mackerels, and we're going

3
00:00:13,950 --> 00:00:17,880
to learn how to do some really interesting things with those elements.

4
00:00:18,510 --> 00:00:22,620
So basically, each and every one of you know how to save a document.

5
00:00:23,100 --> 00:00:27,480
And also what we're going to learn as well is security.

6
00:00:27,490 --> 00:00:30,200
So basically how you can raise your document.

7
00:00:30,900 --> 00:00:36,450
What's cool about this class is that we are going to create buttons basically for our documents.

8
00:00:36,840 --> 00:00:42,120
Well, for our Micheal's, I mean, and we're going to store our microbes inside of those buttons.

9
00:00:42,450 --> 00:00:48,300
And this way, if you guys want to run your microphone instead of having to go here and selecting the

10
00:00:48,330 --> 00:00:52,320
macro that you want, well, what's going to happen is that you will have access to a button.

11
00:00:52,320 --> 00:00:58,140
You will just click on it and will automatically do the task for you, which is pretty cool in my opinion.

12
00:00:59,460 --> 00:00:59,840
All right.

13
00:01:00,300 --> 00:01:07,500
So first step, the first step of what we want to do, we want to save or document and basically we

14
00:01:07,500 --> 00:01:11,140
want to record the micro saving or document.

15
00:01:11,700 --> 00:01:15,210
So how exactly can we save a document on Excel?

16
00:01:15,360 --> 00:01:20,910
And so very simple on your keyboard, you have a shortcut that is controlled.

17
00:01:20,940 --> 00:01:27,090
So simply click on the control button and then s and then you can see it will automatically save your

18
00:01:27,090 --> 00:01:27,660
document.

19
00:01:28,590 --> 00:01:32,220
So what exactly we want to do right now is it's pretty simple.

20
00:01:32,400 --> 00:01:35,520
We simply want to report it inside of a macro.

21
00:01:35,550 --> 00:01:37,450
So this is exactly what we are going to do.

22
00:01:38,490 --> 00:01:46,440
So basically we are going to go here, click on Record Macro and we'll call it a save button.

23
00:01:48,990 --> 00:01:50,440
Then we click on OK.

24
00:01:51,180 --> 00:01:59,450
Now one a record is simply us clicking uncontrol s and then you can stop that recording point.

25
00:01:59,760 --> 00:02:07,560
For those of you who can find the control, you can just go into file and then safe and well, it's

26
00:02:07,560 --> 00:02:08,640
going to be right there.

27
00:02:08,820 --> 00:02:14,970
So basically you just click on Save or you can just click here on the button right there so you can

28
00:02:14,970 --> 00:02:16,110
save your document this way.

29
00:02:18,300 --> 00:02:23,640
So right now, what we will do, we are going to run or so pretty simple will go here.

30
00:02:23,640 --> 00:02:27,070
We can run our macro, which is save button and works pretty fine.

31
00:02:27,390 --> 00:02:27,750
All right.

32
00:02:27,780 --> 00:02:28,920
So what is the next step?

33
00:02:28,920 --> 00:02:31,290
The next step is creating a button for our Mac.

34
00:02:31,410 --> 00:02:32,190
So pretty simple.

35
00:02:32,190 --> 00:02:33,950
How exactly can create a button.

36
00:02:34,410 --> 00:02:35,810
So we're going to go here.

37
00:02:36,000 --> 00:02:37,810
So stay in the developer tab.

38
00:02:38,100 --> 00:02:43,190
We're going to go into insur and here you will have a lot of different buttons that you can create.

39
00:02:43,650 --> 00:02:48,330
So you have buttons if you want to create the survey, you have four different buttons that you can

40
00:02:48,330 --> 00:02:48,600
create.

41
00:02:48,960 --> 00:02:52,350
And you have this button right here, which is in Microsoft.

42
00:02:52,710 --> 00:02:56,100
So we'll click on it and then we'll create ourselves a button.

43
00:02:56,430 --> 00:02:58,050
So we'll call it safe.

44
00:02:59,840 --> 00:03:01,080
It's going to be safe button.

45
00:03:02,630 --> 00:03:07,170
And now we can change the name of it, so we'll call it safe.

46
00:03:09,530 --> 00:03:09,940
Here we go.

47
00:03:10,370 --> 00:03:12,560
So now our button is ready.

48
00:03:15,060 --> 00:03:21,000
So it should work perfectly fine, so the next step will simply be testing our button and how exactly

49
00:03:21,000 --> 00:03:22,370
can we test this buttons?

50
00:03:22,380 --> 00:03:26,850
Pretty simple just by clicking on it so we can go here and just click on our button and you can see

51
00:03:27,160 --> 00:03:29,560
it works perfectly good.

52
00:03:29,580 --> 00:03:35,580
So right now, you know how to create a button that you can well, where you can integrate your microphone

53
00:03:36,000 --> 00:03:38,760
in and basically what exactly you can do.

54
00:03:38,760 --> 00:03:40,830
Besides of this, it's pretty simple.

55
00:03:41,430 --> 00:03:45,780
You can well save a whole macro inside of a button.

56
00:03:45,810 --> 00:03:51,360
So basically, the MICU that we have that we have created in the best class, it's possible to create

57
00:03:51,360 --> 00:03:54,800
a button and basically said your macro inside of this button.

58
00:03:54,810 --> 00:03:58,280
So each time we click on the button, it's going to be a shortcut for your macro.

59
00:03:59,250 --> 00:03:59,620
All right.

60
00:03:59,850 --> 00:04:03,100
Next thing that we are going to learn today is protecting your documents.

61
00:04:03,100 --> 00:04:09,870
So basically, let's say you want to protect the sheep and how exactly can you protect what?

62
00:04:09,870 --> 00:04:10,800
I'm talking about protection.

63
00:04:10,810 --> 00:04:13,050
I'm talking about password protection.

64
00:04:13,230 --> 00:04:16,050
And this is exactly what we are going to do today.

65
00:04:16,710 --> 00:04:17,450
So pretty simple.

66
00:04:17,460 --> 00:04:24,540
We are going to basically protect our document with a well, with a password.

67
00:04:24,810 --> 00:04:25,300
So it works.

68
00:04:25,500 --> 00:04:30,150
It works pretty much the same way as I well, as I told you.

69
00:04:31,230 --> 00:04:39,450
So we are going to create a macro that will help us, that will allow us to basically create a password

70
00:04:39,450 --> 00:04:40,140
for our documents.

71
00:04:40,620 --> 00:04:41,330
So pretty simple.

72
00:04:41,340 --> 00:04:44,980
We're going to protect and protect or document with the use of a macro.

73
00:04:46,140 --> 00:04:48,150
So pretty simple how to protect the documents.

74
00:04:48,270 --> 00:04:53,970
First thing, you will go into the review tab and here you will have those two elements right here.

75
00:04:54,220 --> 00:04:55,680
So you have to protect your sheet.

76
00:04:55,730 --> 00:04:57,000
So basically, what does this mean?

77
00:04:57,000 --> 00:05:02,160
This means protect your document and you have protect the workbook.

78
00:05:02,170 --> 00:05:04,170
So basically that's for the whole workbook.

79
00:05:05,370 --> 00:05:07,620
So we'll just work with the protected.

80
00:05:07,800 --> 00:05:08,480
So pretty simple.

81
00:05:08,490 --> 00:05:14,720
It's going to be for select for lucht cells and for unlocked cells so we can be more complicated.

82
00:05:14,730 --> 00:05:17,610
You can, for example, protect only some things.

83
00:05:17,610 --> 00:05:22,140
So for example, you can protect roads, you can protect some columns, you can protect some types of

84
00:05:22,140 --> 00:05:22,520
cells.

85
00:05:23,040 --> 00:05:24,900
We are going to protect the whole document.

86
00:05:24,930 --> 00:05:25,530
So pretty simple.

87
00:05:25,980 --> 00:05:30,090
So we'll just click on, OK, and right now we are not going to integrate no passwords to it.

88
00:05:30,330 --> 00:05:31,450
So we'll just click on, OK.

89
00:05:32,160 --> 00:05:33,650
So right now, are Sheedy's protected?

90
00:05:33,660 --> 00:05:34,520
How can we test it.

91
00:05:34,530 --> 00:05:35,230
Pretty simple.

92
00:05:35,250 --> 00:05:40,580
Just click somewhere and as you can see, the cell or chart your change is on a protected sheet.

93
00:05:41,640 --> 00:05:43,210
So we need to unprotected.

94
00:05:43,560 --> 00:05:45,000
So how do we protect it?

95
00:05:45,000 --> 00:05:53,940
We just click here so we can try it out again and we can try our safe macro and we can click on protection.

96
00:05:54,540 --> 00:05:56,550
So right now, what we are going to do is pretty simple.

97
00:05:56,550 --> 00:06:00,450
We are going to protect our sheet with a Mac.

98
00:06:00,580 --> 00:06:02,130
So pretty simple how exactly we do this.

99
00:06:02,580 --> 00:06:05,300
So the same way that we have created this button right here.

100
00:06:05,700 --> 00:06:09,940
So there will record a macro when we are protecting our.

101
00:06:11,400 --> 00:06:18,330
So will the man who will call it protection is going to be OK.

102
00:06:18,360 --> 00:06:21,210
So right now we are going to create or so pretty simple.

103
00:06:21,570 --> 00:06:26,430
We come back in the review tab and we just click on Protect the Sheet.

104
00:06:27,090 --> 00:06:32,280
And then if you guys want to add a password, it's possible, but we're not going to do it for the purpose

105
00:06:32,280 --> 00:06:32,750
of this course.

106
00:06:32,760 --> 00:06:33,910
We'll just click on, OK?

107
00:06:34,950 --> 00:06:37,650
And right now our well, everything works fine.

108
00:06:37,660 --> 00:06:40,840
So she's protected so we can stop recording or micro.

109
00:06:42,120 --> 00:06:47,250
So right now we are going to come back here because we need to protect it since it's protected.

110
00:06:47,250 --> 00:06:51,780
And what we're going to do is create a button for this wall for this protection.

111
00:06:52,800 --> 00:07:00,410
So pretty simple how we are going to do this the same way that we did for the well, the best element.

112
00:07:00,630 --> 00:07:04,760
So we'll come back to our developer table, click on insur and we'll create our button.

113
00:07:05,370 --> 00:07:06,690
So it's going to be right there.

114
00:07:08,360 --> 00:07:13,670
And we'll call it what it's going to be protection and we'll call our border protection

115
00:07:17,730 --> 00:07:22,480
protection good, so everything works fine.

116
00:07:22,560 --> 00:07:27,740
Right now, if we click on this button right here and we try to work on our sheet, it's not going to

117
00:07:27,740 --> 00:07:29,080
work because it's protected.

118
00:07:29,870 --> 00:07:31,370
So I'm trying it again.

119
00:07:33,200 --> 00:07:33,860
It's protected.

120
00:07:33,860 --> 00:07:34,610
So it's not going to work.

121
00:07:34,760 --> 00:07:35,350
Pretty simple.

122
00:07:36,530 --> 00:07:38,870
So I'll come back right here in my.

123
00:07:40,200 --> 00:07:45,450
Review to and I'll protect the worksheet, so I know, let's say I want to protect all how important

124
00:07:45,450 --> 00:07:49,190
to protect my shit so works pretty much the same way.

125
00:07:49,530 --> 00:07:55,620
So I go here, I click on protection, and right now I'll protect my sheets or create a macro specially

126
00:07:55,620 --> 00:07:56,030
for this.

127
00:07:56,040 --> 00:08:00,030
So a macro to call it on protect.

128
00:08:02,640 --> 00:08:09,570
And then I'll simply do what I need to do, so I'll go back and review, I'll click on Unprotected and

129
00:08:09,570 --> 00:08:09,940
that's it.

130
00:08:09,960 --> 00:08:13,740
My my crew is done, so stop the recording part.

131
00:08:14,190 --> 00:08:16,590
So I know what I can do is pretty simple.

132
00:08:16,590 --> 00:08:19,580
I can just create a button that will protect my shit.

133
00:08:19,920 --> 00:08:23,040
But let's first test our macro if it works perfectly.

134
00:08:23,040 --> 00:08:25,230
So we are going to protect our shit now.

135
00:08:25,230 --> 00:08:28,140
We're going to run the macro that we have just created.

136
00:08:28,140 --> 00:08:30,990
So it's going to be UN protection and protect right there.

137
00:08:31,260 --> 00:08:32,010
So if we run it.

138
00:08:33,820 --> 00:08:36,260
As you can see, everything works perfectly fine.

139
00:08:37,270 --> 00:08:38,840
So right now, we'll create a button for it.

140
00:08:39,070 --> 00:08:39,820
So pretty simple.

141
00:08:39,840 --> 00:08:45,380
We'll come back here in, insert them and we're going to create a button that we are going to call unprotected.

142
00:08:47,500 --> 00:08:48,790
So it's going to be on protect.

143
00:08:55,000 --> 00:08:59,290
And good, so we have our button that works pretty fine.

144
00:08:59,560 --> 00:09:01,420
So right now it's time to test our buttons.

145
00:09:01,450 --> 00:09:04,780
So first of all, we want to protect our she or she is protected.

146
00:09:04,780 --> 00:09:05,860
So we try it out.

147
00:09:06,640 --> 00:09:08,170
As you can see, it's not working now.

148
00:09:08,170 --> 00:09:10,500
We protect the sheep and everything works fine.

149
00:09:10,510 --> 00:09:11,080
So it's perfect.

150
00:09:11,080 --> 00:09:12,790
And now we can keep our documents.

151
00:09:13,240 --> 00:09:17,980
So I now, as you can see, we have basically stored all those tasks inside three buttons.

152
00:09:18,250 --> 00:09:24,550
Basically, you guys can use those buttons for, well, any purpose that you want inside of your Excel

153
00:09:24,550 --> 00:09:25,540
spreadsheet.

154
00:09:25,540 --> 00:09:31,110
So you can see it's possible to store macros inside of buttons, which is pretty cool in my opinion.

155
00:09:31,120 --> 00:09:35,810
And those are pretty simple macros and macros that you can use on a daily basis.

156
00:09:36,610 --> 00:09:38,690
Let's say you want to protect automatically your sheeple.

157
00:09:38,710 --> 00:09:43,810
You just click on the button and it's protected and it's protected with a password and you can decide

158
00:09:43,810 --> 00:09:48,500
the password that you want to use and then to unprotected, for example, you just enter the password.

159
00:09:49,360 --> 00:09:54,430
So basically, if you want to protect automatically your sheet, let's say you're working at your workplace

160
00:09:54,670 --> 00:09:55,720
and you want to protect your sheet.

161
00:09:55,720 --> 00:09:59,530
Well, now you know how to use a simple button to protect it automatically.

162
00:10:00,220 --> 00:10:02,280
So I hope this will help you.

163
00:10:02,710 --> 00:10:06,250
So it's a first class guys into all in our next class.