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

Herb,

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

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

Look at Chip Pearson's site for the basics:

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

--
Regards,
Tom Ogilvy

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