Best way to package workbook and UDFs

[Prof Wonmug]

I want to send a workbook to a colleague. It makes use of several UDFs
that I have stored in my personal add-in module. I don't want to send
the entire add-in module, just a few UDFs.

My plan is to create a separate add-in module, copy the selected UDFs
to that module, and send that along with the workbook.

Is there a better way?

 

[JLGWhiz]

If you only want to send the code, you could copy it to Notepad or Word as a
text file to send it. The recipient can then copy it to whereever they want
and will not have to worry about any inherent anomallies.

 

[Gord Dibben]

Copy the several UDF's to a module in the workbook you are sending.


Gord Dibben MS Excel MVP