You can store the UDF in a general module in the workbook in question.

Alt + F11 then CTRL + r.

Select you workbook/project and InsertModule.

Place the UDF in that module and Save the workbook.

The UDF will stay with the workbook.


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 06:40:01 -0800, slymeat .(donotspam)
wrote:

Is there a way that a user defined function can reside within the file itself?

If i email an excel sheet to another person and it contains user defined
functions, they don't work for the recipient. Is there a way round this?