I also have tried copying controls from a userform to a worksheet. Have never
succeeded. However, it shouldn't be hard to write a macro which would store the
properties of a userform command button  in an array, then create a new button on
a worksheet  and format it with the stored property values.