Macro to populate Event-Driven macros to certain sheets

[dicenn]

Hi,

I run a macro every day which creates a given output. I want to add event-driven macros to some of the sheets in my workbook, but I want this to be done automatically when I run my initial macro.

Is there any way I can have a macro add event-driven macros that I have already created to certain sheets?

Let me know if you need additional information.

Thank you,

T

[Norie]

Are you creating new worksheets every day?

[dicenn]

Yes, the sheets where I want to add the event driven macro are created daily. I work on a new workbook with one input sheet every day.

Also, the macro is run from a separate workbook than the output. The macro creates a new book for my output.

[Norie]

You could use code to create the event-driven code but it would be far easier to use a template or use workbook level event code.

[dicenn]

Template may be best in this case since the workbook level event code would still have to be added to the new workbook created by the macro (right?).

Thanks,

T

[Norie]

Well you could use a template workbook.