copying macro to a new workbook

[JT]

Workbook 1 contains a push button. Attached to the push
button is a macro that performs a couple of edits and
sends an e-mail.

I have another macro that makes copies of the data in
Workbook 1 for each business unit. Each copy contains the
same push button. However, the macro attached to the push
button in Workbook 1 is not carried forward with the
copies of the data for each business unit.

Any help in copying the data and macro to the "new"
workbooks would be appreciated. Thanks

 

[Ron de Bruin]

Hi JT

If you copy a whole worksheet to a new workbook and send that then
you can use a button from the Control toolbox and copy your code in the
Click event of this button.(This is in the Sheet module)

 

[Guest]

Ron,

I also want to copy a micro to a new wookbook but I want to automate the
process so the the macro copy s done without user action.

I have tried the mergeworkbook method but it does not copy the macro.

Is there VB code that will copy a macro to a new workbook without user
intervention?

Thanks,
Ed

 

[Tom Ogilvy]

Try looking at Chip Pearson's page on working with code in the VBE

http://www.cpearson.com/excel/vbe.htm