Common module by multiple workbooks
 

I have a number of workbooks (say 30) that all have one module wit
exactly the same code in them. Every time I make some changes in th
code, I have to update all workbooks.
*Is there a way to use one common module which will be someho
called/referenced by all workbooks?*

Thank

--
S@
-----------------------------------------------------------------------
S@S's Profile: http://www.excelforum.com/member.php...fo&userid=1606
View this thread: http://www.excelforum.com/showthread.php?threadid=27519

Common module by multiple workbooks
 

Save the code in your Personal.xls, which is saved in your xlstart folder.
If the file doesn't exist, create one. Whenever you open Excel, the
personal.xls file in folder xlstart will open and be hidden. However, you
can see it in the VB Editor projects. Any macro in your Personal.xls will
now be available for any open workbook to use.

Mike F
"S@S" wrote in message
...

I have a number of workbooks (say 30) that all have one module with
exactly the same code in them. Every time I make some changes in the
code, I have to update all workbooks.
*Is there a way to use one common module which will be somehow
called/referenced by all workbooks?*

Thanks


--
S@S
------------------------------------------------------------------------
S@S's Profile:
http://www.excelforum.com/member.php...o&userid=16062
View this thread: http://www.excelforum.com/showthread...hreadid=275190