By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

copying macro enabled sheets

P: 2
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
Apr 22 '10 #1
Share this Question
Share on Google+
2 Replies


P: 2
@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
Apr 22 '10 #2

Frinavale
Expert Mod 5K+
P: 9,731
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
Apr 30 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.