Help with a macro (sorry I'm really new)

[RMWarner]

Hello everyone,
I recorded a macro to extract a worksheet from a workbook so I can save a copy of it elsewhere and leave the original work sheet unchanged (as a template of sorts). It works fine with one exception. Once the macro is run and the page is extracted the button that I've made no longer has the macro assigned to it. How can I fix this?

 

[bjurney]

Are you using a button from the forms or one of the activex controls? I prefer the activex controls in the VBA toolbox rather then the forms. But they differ in some ways. If you put in a command button from the control toolbox, double click it and then either copy and paste your code in there, or put in something to the effect

Call mymacroname