Macro to copy a macro?

[IAmLemondrop]

Is it possible to create a macro that copies a different macro to an existing worksheet?</SPAN>

I’ve created a macro for another person to format their reports. I’ve given instructions to open the worksheet I’ve created, then open their file with the data and run one of 10 macros to format their report. The problem is that after the formatting is done and before the report is sent out it needs to contain a macro so the final end user can run a page break macro if they need to.</SPAN>

I can't put everything in one file because I don’t want the end user to see my formatting macros (it serves no purpose for them at that point anyway). I could create a new workbook with the page break macro already in it, however I’m trying to avoid having the other person copy/paste from one worksheet to another for 10 different reports.</SPAN>

Any ideas?</SPAN>

 

[Biz]

If in MS Excel 2010 then save it as not macro enabled file. Macro drops off automatically.

Alternative macros you don't want user to see type word "Private" in from macro . For instance, Private Sub Test(). Word Private hides macro when you press ALT+F8

 

[IAmLemondrop]

Sorry, I guess I didn't state that clearly. I want to add a macro to the final product. I already have the user opening 1 file that has all the macros and then opening their files (10) with the data. I can create templates with the page break macro already included, but I wanted to avoid having the user opening 10 different templates.

 

[IAmLemondrop]

Never mind. I guess I just didn't search hard enough. I found my answer here: http://www.mrexcel.com/forum/excel-questions/602413-copy-module-new-workbook-add-button.html