copying macro to a new workbook

  • Thread starter Thread starter JT
  • Start date Start date
J

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
 
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)
 
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
 
Back
Top