VBA Create Buttons

[somenoob]

Hi everyone, can anyone help me?

i have to create a button in vba.

in my first spreadsheet, eg.'List', there will be a button to click to create a new spreadsheet. In the new spreadsheet created, i want a button to be auto created with my macro in the cell C1.

How do i code it?

 

[somenoob]

is there anything wrong with my codes? or i have to use the codes you provided recently?

 

[Misca]

The code example I sent you is for the last macro (= the one with the optional name parameter):"Click Me!" is what it reads in the button and "MyNewButton" is the name for the button.

 

[somenoob]

what do you mean by for 'the last macro (= the one with the optional name parameter)'?

 

[Misca]

The "last macro with the optional name parameter" can be found in message number 9.