A User Defined function that is located in a code module in a workbook will go along with the Workbook As long as you share. Likewise the function remains with the workbook and will always be available to share.
If your workbook refers UDF you can save the Macro code –Module in Basic file (.bas) format Mail the. bas file to someone with whom file you want the UDF to be available else you can share the file also.