macro to copy sheet with button and macro

[ericlch16]

Hi

I have a macro that is used to loop and copy a worksheet to another new workbook and name it as a different name. The problem is that the worksheet I am copying contains "buttons" with "assign macro" inside. So when I copy to a new workbook and save it as a different name the macro is not assigned. How to get around it? i.e copy not only the sheet but also the button and its assign macro it contains to a new workbook.

Thanks,
E

 

[JoeMo]

Have you tried putting the macro in the sheet that gets copied rather than in a general module?