How do I Programmatically create a button and assign a macro to it upon opening spreadsheet? : What I need to do upon opening a spreadsheet is to execute some VBA to produce a button for me and automatically assign a macro I have created previously to it, let's call this macro "edit_colour" (which has been pre-recorded and saved).

Now, I know how to Automatically execute (AutoOpen) a MsgBox with "Hello World" using the following,

    Private Sub Workbook_Open()
    MsgBox "Hello World"
    End Sub

However, to create a button programmatically (can't do it any other way unfortunately) and assign "edit_colour" to that macro seems a tad more complex. Can anyone assist with this please?

Thank you!

