Good morning gang. I am trying to write a macro that will create a command button on a sheet and assign VBA code to that button. Basically, my original code creates a new sheet. I would like that new sheet to have button on it that will, when clicked, run another macro.

Here's what I have (of course it doesn't work as intended. The button is created, but the label isn't changed nor is the code assigned):

Sheets.Add.Move Before:=Sheets(1)
'more code follows...then>>>
ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
        , DisplayAsIcon:=False, Left:=369, Top:=27.75, Width:=106.5, Height:= _
        27.75).Select
       Selection.Caption = "My Button"
       Selection.OnAction = "ThisWorkbook.MyCode Here"
Any ideas would be greatly appreciated. Thanks in advance!

Bruce