another way to run a macro is to put a
an actual button on the screen maybe
you've seen uh uh maybe you've seen
spreadsheets where there's an actual
button on the screen and you click on it
and something happens well here's
exactly how they did that you're going
to pick on the developer toolbar now if
you do not have the developer toolbar
here's how you're going to bring that up
you're going to pick on the uh office
button you're going to pick on the Excel
options okay and then you're going to
pick on the pop
tab notice right over here it says show
developer tab in the ribbon when you
first install Excel that's actually
unchecked so you want to make sure that
that's checked then we'll click on okay
and now you should have the developer
tab up on your uh ribbon okay so you're
going to pick on developer in the
previous versions this is called the the
forms toolbar and the control toolbox so
we'll pick on uh under the developer tab
we'll pick on insert and now you're just
going to pick on this guy over here it's
called a button looks like a rectangle
and click on
that move the button onto your screen
somewhere obviously you would pick an an
empty spot I'm going to click there now
as soon as I clicked on that this screen
came up and it wants you to pick a macro
for that button so we'll pick on bold
red of course if you had other macros
they'd be listed there we're going to
click on
okay now if you want to change the text
of the button you can click inside there
and uh maybe we'll call that red
bold if you want to make the button
bigger you can use the sizing handles to
stretch that out as you can see now how
do you run the button well just
highlight your text and then click on
the button notice how the finger comes
up that means the button is activated
and when we click on that the macro runs
so the macro is now associated with the
button the way we added the button was
under the developer toolbar we picked on
insert and then we picked a button as
soon as we did that we we clicked that
on our screen then it showed with that
assign macro window if you want to
change the button notice if I click on
it it actually runs the Macer right so
to change the button you're going to
rightclick on it I I just right clicked
now I can uh cut or copy or paste of
course I can change the text by saying
edit
text but if I rightclick I can assign a
different macro format control is where
You' go in and actually change uh the
appearance of that
button once I right click on that button
if you want to move the button you're
going to move your mouse to the edge of
the button and then just drag it like
that and now we can uh change that
button once I click outside of the
button then it goes back to a just a
working button and if you want to change
it you would right click on it all right
so that's how we can actually add a
button to your screen the the order of
the process would be you would make your
macro first and there's another video
that shows you how to make make a macra
and then from there you can assign a
button that would run that macra