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?

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.



"Prof Wonmug" wrote in message
...
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?

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


Gord Dibben MS Excel MVP

On Wed, 21 Apr 2010 11:31:44 -0700, Prof Wonmug wrote:

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?