Copy Form Control Button to new worksheet using vba

I have a worksheet that is a template to create additional worksheets, however when pressing the form button which saves the current workbook as a new filename, the form control buttons do not copy to the new workbook.

Please Login or Register  to view this content.

the code executes perfectly, however I need to use form control buttons, not command buttons, due to the reliability of the command button which is lacking. I would like to copy all form control buttons to the new worksheets that are created.

Is this possible? I have searched and searched with no answers.

The modules that I have created ARE copying over to the new workbook, i just need to copy over the Form Control button, and assign the macro if necessary to that form controlbutton.


Thank you all in advance.

That didn't work... what worked was changing the Auto Size option under format properties. Thank you for the help though.