Its very easy follow the following simple stemps

Step-I

Select Tools>Customize>ToolBars

Select "New" button/bar appearing at the right side

Fill/Give a name to the newly created emptry tool bar  that will be of
your own and not of excel  built-in ones.

Click OK

Select/click the square i.e. select this new bar to appear alongwith
other tool bars or somewhere on the screen

Step-II

Tools>Customize>Commands (this time Commands and not ToolBars)

From the categories list select "Micros"

From the Command List of "Micros" catogary appearing on the right side
drag either Custom Menu item or Custom button  (yellow in color) to your
newly created toolbar

Step-III

Immediately after dragging the Custom Button to your tool bar right
click it.

Select last item - Assign Micro

Select the Micro name of your program  from the list

press OK

From now onwards your program should run whenever you click/press this
button.

For changing the options or even the button do the following

While/After selecting Tools and then Customize (Tools>Customize)

right click the button you can change the name of the button, Edit or
Change the button itself and u can do with many options available and
continue

Hope the above will help u

In case of difficulty please send your worksheet

I have learnt the above procedure from Help

You may frequently use Help for all your qurries to improve