Hey. I am using a button on a custom-made form to create a new worksheet. Clicking the button will:
1. Ask for a name
2. Make a worksheet using that name
3. Give worksheet a random color
4. Insert Name into A1
5. Bold, and change name to size 24 in A1
6. Insert a command button into the new worksheet.
Step #6 is the ONLY one that doesn't work, mostly because I don't know how to do it. Another worksheet has a command button on it already that is attached to a totally different macro. I would like an exact duplicate of that command button on every new page added with this user form. (It can't be a copy and paste code in case I should update the other button in the future.) How can I use VBA code to automatically create a working command button for step 6?