If the macro needs to be available for any workbook they have open then you have two main choices. You can either get them to put it in their personal.xls or you can distribute it as an add-in. The add-in would be the better choice here but it would also come with a fairly significant learning curve.
|