Shared VBA code between workbooks

Hi,

I have a number of workbooks that are used as timesheets. Each employee has their own workbook, which contains a separate sheet for each week's data. The workbooks are all stored in the same LAN directory.

I have several functions / subs in each workbook that are identical - what would be the best way of maintaining only one version of this code and allowing the individual workbooks to access it?

I would guess at creating an add-in and storing it on the LAN - is this the best way?

Thanks,
Vindaloo

Since creating this thread I've done the following:

Removed the module from the original workbook and saved it as an XLA.
Loaded this XLA using Tools --> Add-ins
Added a reference to the XLA Project so that the original workbook can use the subs / functions in the XLA.

Does this sound about right before I modify everyone's timesheet to use the new add-in?

Thanks,
Vindaloo