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)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JT" wrote in message ...
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,

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

"Ron de Bruin" wrote:

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)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JT" wrote in message ...
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

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

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

--
Regards,
Tom Ogilvy


"Ed" wrote in message
...
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

"Ron de Bruin" wrote:

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)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JT" wrote in message
...
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