Hello,

I have a macro that copies all rows related to a Sales Representative from a
main workbook and creates a new workbook for each Sales Representative. How
do I attach a different macro to one of the sheets of the newly created
workbook?

Thanks,

Why not create a template with the macro already in it and then when the
main workgroup creates the new workbook have it create it from the template.

--
Rui Caetano
IT Manager
Township of East Hanover, NJ

"C. Corodan" <(E-Mail Removed)> wrote in message
news:8E49E2EC-9C56-454A-AA4A-(E-Mail Removed)...
> Hello,
>
> I have a macro that copies all rows related to a Sales Representative from
> a
> main workbook and creates a new workbook for each Sales Representative.
> How
> do I attach a different macro to one of the sheets of the newly created
> workbook?
>
> Thanks,

Chip Pearson shares some VBA techniques for writing code that writes code.
http://www.cpearson.com/excel/vbe.aspx

Personally, I think creating a template workbook that contains all the code I
need and then using that to create the new workbooks would be lots easier.

C. Corodan wrote:
>
> Hello,
>
> I have a macro that copies all rows related to a Sales Representative from a
> main workbook and creates a new workbook for each Sales Representative. How
> do I attach a different macro to one of the sheets of the newly created
> workbook?
>
> Thanks,

--

Dave Peterson