You can edit the button completely through the properties option. Select it and you have a list of the properties, including background colour, font etc.
If you want to run a macro by clicking the button, the easiest way is to choose view code.
If you enter the following (some is done for you) - assuming the macro is called macro1 :
Private Sub CommandButton1_Click()
then that ties the macro to the button :)
hope this helps.
Chances are the other options you have seen before were from an older version of Excel.