Best way to send workbook with UDFs?

[JenniferMurphy]

I have some workbooks that friends or family members have asked for. Most of them make use of UDFs that are in my personal add-in module. I don't want to give them the entire add-in module for several reasons. What's the best way to make these workbooks transportable?

If I copy the UDFs to a code module in the workbook, I run into a couple of problems. First, I have to change the filetype to xlsm, which complicated life for the recipients. Second, I have to them remove it for my use or I will have duplicate UDFs, which makes updates error prone.

Any suggestions?

Thanks

 

[Coding4Fun]

You could look at creating it as an Add-In and have the user install that, not sure if that would be an option in your case. This would allow them to install it once and then would not need to change the file format each time.

I might be misunderstanding your request.

 

[JenniferMurphy]

You could look at creating it as an Add-In and have the user install that, not sure if that would be an option in your case. This would allow them to install it once and then would not need to change the file format each time.

I might be misunderstanding your request.

My objectives in order of importance are:

1. Simplicity for the other person. Asking them to install an add-in just for this one workbook is probably too much. Giving them a macro-enabled workbook is a nuisance and confusing for non-techies.
2. Simplicity for me. Having the UDF in two places is a serious complication.

I can't think of a solution that meets both criteria or even really comes close. The least bad solution is probably copying the UDFs to a workbook code module and then deleting it (or commenting it out) after I send it. That eliminates the need to maintain two copies, but requires that I remember to recopy it if I send it out again. (sigh)

Thanks