Is it possible to have a centralized module that you can share in multiple workbooks, and have any changes made to that central module pulled throught to the wrokbooks its used in.

For example, a module that can be used to do numerous worksheet formatting routines.

Or will I have to insert the module into each workbook and make the changes to each module in each workbook its used in?

Thanks!