Macro to Create Button and assign code

Originally Posted by raypayette

This is the code to add a button and assign a macro:
ActiveSheet.Buttons.Add(111, 51.75, 42.75, 13.5).Select
Selection.OnAction = "Macro1"

I know I'm bringing this thread back from the dead but I have a slight problem.

I wrote a macro that does the following:
Create a button on a new sheet, assign it an onaction macro, then move it to a new workbook where the macro is added through a BAS file. Now unfortunately the onaction does not point to the correct macro. How can I fix it?

Thanks in advance!

Maxim