Assigning macro to a button icon in spreadsheet

just get a button from the forms tool bar the first thing youll see as you do it is assign macro
or get a command button from the control toolbox
right click it view code
then just put your macro name like this (where mymacro1 is the name of your existing macro)

Please Login or Register  to view this content.

edit the button label as you see fit in commandbutton object
then click the triangle thingy in the left hand side of the command tool bar to exit design mode