Build Macro to create a button, name it, and attach to existing macro

[dyana]

I recorded a macro in Excel to create a button, that when involked would run a series of other macro. Unfortunately when I tried to run this recorded macro it would not work.

When recording this macro, I renamed the button from "button 1" to "Execute Process". Yet I think that the VBA code still sees it as button 1, because when I try to run it, it states that button 1 already exists.

How can I create the VBA code to create a button, then name it "Execute Process", then attach it to a macro called "Process"?

Thanks

 

[CDN]

when you record the macro, you can name it what you want. See if that works

​

 

[dyana]

That's what I tried and it did not work.

 

[acron]

The following will add a Button fron the Forms toolbox (not an ActiveX control from the Control Toolbox) and assign a procedure named Process to it.

    ActiveSheet.Buttons.Add(35.25, 19.5, 81, 21).Select
    With Selection
        .Name = "Execute Process"
        .OnAction = "Process"
    End With

The values in brackets determine the size and position of the button on the sheet, and may need some experimentation. Best way to experiment is to record creating the button exactly where you want it, and substitute the values obtained in the above.

A.C.