Copying a macro to a new worksheet

[kajero]

Is there any code that can be written so when a person selects a tab to be moved to a new workbook, the macro code in the existing workbook would be copied to the new sheet? I'd also like to use a button that the user could click on for the macro.

Thanks for any help you can send my way.

 

[Michael M]

Have a look here, especially at Chip Pearson site in Post #2

http://www.mrexcel.com/forum/excel-...ual-basic-applications-code-new-workbook.html

 

[kajero]

Have a look here, especially at Chip Pearson site in Post #2

http://www.mrexcel.com/forum/excel-...ual-basic-applications-code-new-workbook.html

Oh my gosh. I NEVER even thought of this. Why do people have to wreck things for people who just want a simple procedure that would help others????

 

[kajero]

One other question then. When I send a copy of a workbook I created that has macros is the same thing that is used to cause a Code Red Virus?