In the new version of Visual Studio there are tools for offic
application development.
You can put your COMMON routines in there ( in vb.net or C#.net) creat
a .dll file
and put a reference to that file in each workbook.
When you add routines to the .dll everybody is automatically updated.

If you have more questions about this let me know

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=39121