8 hours 33 minutes
So when we created this macro copy constants,
we have assigned it to a shortcut keeper Charcot, which was control shift. Then,
um, you can also assign macro
toe a button that you creating an excel. So, for example, during some calculation, and in the end, you want to start your macro anyone people to be able to use it without actually remembering what?
What shortcut is for that macro? Or you have several Mac Rose and you want them
So you go
here the home
and you go to shapes and you select some shape you want to use. For example,
and then you added techs just
So you want to these continents to be this? This doesn't have to be the same.
text, like in the name of the macro, just has to describe you what you want to do with it.
So we put it centered, just make it nicer.
We select the text and we can make it larger just
for it to fit better into button.
Then click on button.
And we have the option to assign macro,
and it will give us the
name of the macro by default, which is the name of the object. We're assigning macro too. But we actually want to assign
You just say OK,
so let's hear type
so we have formulas here
and we click here and we get concert. So the macro has been executed,
have now the
button that is
doing the same function as a keyboard shortcut.
But it is now completely clear
to everybody using this.
They s spreadsheet, the worksheet, what it's actually doing. Now, you see that
when we click here and we try to move it,
it will just perform the macro again again. So if you want to move this,
put it in some other position In inside
you have to,
cut it and placed it somewhere else.
or you can do it with control.
So you can you can
click here on the edge of it.
Sorry. Come here, press control.
And then you can move it around. You release the control before you,
released the mouse button. Because in that case
it will make a copy like I just did before. So this is it. So we just moved it. It's active, so you cannot still anything with it
while he's like that.
uh, this is about the basic
micro, how to create it, how to edit it
and also how to, um,
assign it to a button.