Those UDF's shoud be in a VBA module in that workbook's VBA project, to work on any computer that opens that workbook . UDF from an add-in works only for your computer. Another way is that you send them the add-in to be installed on those computers.