copying macro enabled sheets

[Jim Gillmore]

I have created macros in an Excel spreadsheet. I have named the spreadsheet Template.xlsm and want to copy it along with the buttons and associated macros to other sheets called SalesYYMMDD. My script copies it fine but the buttons and macros are left behind. I am saving the macros in Personal.xlsb
I am using Excel 2007

I am stumped and frustrated does anyone have an idea that would helpe copy the sheet to another keeping the macros and buttons intact?
Thanks
Jim Gillmore

[Jim Gillmore]

I have created macros in an Excel spreadsheet. I have named the spreadsheet Template.xlsm and want to copy it along with the buttons and associated macros to other sheets called SalesYYMMDD. My script copies it fine but the buttons and macros are left behind. I am saving the macros in Personal.xlsb
I am using Excel 2007

I am stumped and frustrated does anyone have an idea that would helpe copy the sheet to another keeping the macros and buttons intact?
Thanks
Jim Gillmore

Disregard I finally found the problem the vbscript that was copying the template was working correctly but I had the personal.xlsb hosed. once straightened out it all works

[Frinavale]

I'm glad that you figured out your problem.
Thank you for posting the solution for others to see.

You posted in the wrong forum. I've moved your question to the Access/Excel forum.

-Frinny