code to add module

[Herb]

Is there a way to code some code to insert a module in
another spreadsheet? I have to update the same module in
about 15 sheets. These 15 sheets have different names. I
could do it manually, but it seems to me that should be
able to do this with some VB code.

Thanks in advance............Herb

 

[steve]

Herb,

See if this site is of help..
http://www.cpearson.com/excel/codemods.htm

 

[Tom Ogilvy]

Look at Chip Pearson's site for the basics:

http://www.cpearson.com/excel/vbe.htm