Generating a button with a macro using a macro?

[jose001]

Hey Guys, Is it possible to generate a button with a macro attached? I have a userform which generates a new sheet when its submitted. I would also like it to generate a shape on that sheet which, when clicked, takes the user back to sheet1. Is this possible. I can generate the shape but how on earth to I code it?

 

[Norie]

This probably is possible, this link might help,Programming to the VBE.

But why not just create a template worksheet and copy that instead of just creating a new, blank worksheet?