code to attach a macro to a newly created worksheet
 

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,

code to attach a macro to a newly created worksheet
 

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

code to attach a macro to a newly created worksheet
 

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