Add code to a worksheet programatically
I rarely have to post questions anymore because the use group history
has an answer for just about any question you can think of. But here's
one that I need help on. I have a workbook I call "Master.xls" with
VBA code which opens & manipulates several other workbooks. One of the
things I would like to do in each of the other books is add a
Worksheet_Change event to sheets in the workbooks. There are hundreds
of them so doing it manually isn't really an option. How can I use VBA
to add code to a worksheet module in another open workbook? Thanks a
lot gurus.
|