View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Best way to package workbook and UDFs

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?