Copying Workbook Event Procedure Programatically
Posted by Bill on October 25, 2000 11:19 AM
I have a macro that creates a series of new workbooks. I need to copy Module1 from a source book to each new book, and I need to copy Workbook_Activate from the source book to each new book.
I was able to copy Module1 by using:
How do I copy (or even programatically rewrite) the workbook_activate event handler?