code to add module
 

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

code to add module
 

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

code to add module
 

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