Hello and welcome back to another class of our course about the complete introduction to accept the
I'm so into this class, we are going through what we're still talking about mackerels, and we're going
to learn how to do some really interesting things with those elements.
So basically, each and every one of you know how to save a document.
And also what we're going to learn as well is security.
So basically how you can raise your document.
What's cool about this class is that we are going to create buttons basically for our documents.
Well, for our Micheal's, I mean, and we're going to store our microbes inside of those buttons.
And this way, if you guys want to run your microphone instead of having to go here and selecting the
macro that you want, well, what's going to happen is that you will have access to a button.
You will just click on it and will automatically do the task for you, which is pretty cool in my opinion.
All right.
So first step, the first step of what we want to do, we want to save or document and basically we
want to record the micro saving or document.
So how exactly can we save a document on Excel?
And so very simple on your keyboard, you have a shortcut that is controlled.
So simply click on the control button and then s and then you can see it will automatically save your
document.
So what exactly we want to do right now is it's pretty simple.
We simply want to report it inside of a macro.
So this is exactly what we are going to do.
So basically we are going to go here, click on Record Macro and we'll call it a save button.
Then we click on OK.
Now one a record is simply us clicking uncontrol s and then you can stop that recording point.
For those of you who can find the control, you can just go into file and then safe and well, it's
going to be right there.
So basically you just click on Save or you can just click here on the button right there so you can
save your document this way.
So right now, what we will do, we are going to run or so pretty simple will go here.
We can run our macro, which is save button and works pretty fine.
All right.
So what is the next step?
The next step is creating a button for our Mac.
So pretty simple.
How exactly can create a button.
So we're going to go here.
So stay in the developer tab.
We're going to go into insur and here you will have a lot of different buttons that you can create.
So you have buttons if you want to create the survey, you have four different buttons that you can
create.
And you have this button right here, which is in Microsoft.
So we'll click on it and then we'll create ourselves a button.
So we'll call it safe.
It's going to be safe button.
And now we can change the name of it, so we'll call it safe.
Here we go.
So now our button is ready.
So it should work perfectly fine, so the next step will simply be testing our button and how exactly
can we test this buttons?
Pretty simple just by clicking on it so we can go here and just click on our button and you can see
it works perfectly good.
So right now, you know how to create a button that you can well, where you can integrate your microphone
in and basically what exactly you can do.
Besides of this, it's pretty simple.
You can well save a whole macro inside of a button.
So basically, the MICU that we have that we have created in the best class, it's possible to create
a button and basically said your macro inside of this button.
So each time we click on the button, it's going to be a shortcut for your macro.
All right.
Next thing that we are going to learn today is protecting your documents.
So basically, let's say you want to protect the sheep and how exactly can you protect what?
I'm talking about protection.
I'm talking about password protection.
And this is exactly what we are going to do today.
So pretty simple.
We are going to basically protect our document with a well, with a password.
So it works.
It works pretty much the same way as I well, as I told you.
So we are going to create a macro that will help us, that will allow us to basically create a password
for our documents.
So pretty simple.
We're going to protect and protect or document with the use of a macro.
So pretty simple how to protect the documents.
First thing, you will go into the review tab and here you will have those two elements right here.
So you have to protect your sheet.
So basically, what does this mean?
This means protect your document and you have protect the workbook.
So basically that's for the whole workbook.
So we'll just work with the protected.
So pretty simple.
It's going to be for select for lucht cells and for unlocked cells so we can be more complicated.
You can, for example, protect only some things.
So for example, you can protect roads, you can protect some columns, you can protect some types of
cells.
We are going to protect the whole document.
So pretty simple.
So we'll just click on, OK, and right now we are not going to integrate no passwords to it.
So we'll just click on, OK.
So right now, are Sheedy's protected?
How can we test it.
Pretty simple.
Just click somewhere and as you can see, the cell or chart your change is on a protected sheet.
So we need to unprotected.
So how do we protect it?
We just click here so we can try it out again and we can try our safe macro and we can click on protection.
So right now, what we are going to do is pretty simple.
We are going to protect our sheet with a Mac.
So pretty simple how exactly we do this.
So the same way that we have created this button right here.
So there will record a macro when we are protecting our.
So will the man who will call it protection is going to be OK.
So right now we are going to create or so pretty simple.
We come back in the review tab and we just click on Protect the Sheet.
And then if you guys want to add a password, it's possible, but we're not going to do it for the purpose
of this course.
We'll just click on, OK?
And right now our well, everything works fine.
So she's protected so we can stop recording or micro.
So right now we are going to come back here because we need to protect it since it's protected.
And what we're going to do is create a button for this wall for this protection.
So pretty simple how we are going to do this the same way that we did for the well, the best element.
So we'll come back to our developer table, click on insur and we'll create our button.
So it's going to be right there.
And we'll call it what it's going to be protection and we'll call our border protection
protection good, so everything works fine.
Right now, if we click on this button right here and we try to work on our sheet, it's not going to
work because it's protected.
So I'm trying it again.
It's protected.
So it's not going to work.
Pretty simple.
So I'll come back right here in my.
Review to and I'll protect the worksheet, so I know, let's say I want to protect all how important
to protect my shit so works pretty much the same way.
So I go here, I click on protection, and right now I'll protect my sheets or create a macro specially
for this.
So a macro to call it on protect.
And then I'll simply do what I need to do, so I'll go back and review, I'll click on Unprotected and
that's it.
My my crew is done, so stop the recording part.
So I know what I can do is pretty simple.
I can just create a button that will protect my shit.
But let's first test our macro if it works perfectly.
So we are going to protect our shit now.
We're going to run the macro that we have just created.
So it's going to be UN protection and protect right there.
So if we run it.
As you can see, everything works perfectly fine.
So right now, we'll create a button for it.
So pretty simple.
We'll come back here in, insert them and we're going to create a button that we are going to call unprotected.
So it's going to be on protect.
And good, so we have our button that works pretty fine.
So right now it's time to test our buttons.
So first of all, we want to protect our she or she is protected.
So we try it out.
As you can see, it's not working now.
We protect the sheep and everything works fine.
So it's perfect.
And now we can keep our documents.
So I now, as you can see, we have basically stored all those tasks inside three buttons.
Basically, you guys can use those buttons for, well, any purpose that you want inside of your Excel
spreadsheet.
So you can see it's possible to store macros inside of buttons, which is pretty cool in my opinion.
And those are pretty simple macros and macros that you can use on a daily basis.
Let's say you want to protect automatically your sheeple.
You just click on the button and it's protected and it's protected with a password and you can decide
the password that you want to use and then to unprotected, for example, you just enter the password.
So basically, if you want to protect automatically your sheet, let's say you're working at your workplace
and you want to protect your sheet.
Well, now you know how to use a simple button to protect it automatically.
So I hope this will help you.
So it's a first class guys into all in our next class.