Hi Floyd,

Try, instead, putting your udf's in an addin.


---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
My boss wants to have each worksheet as a standalone entity, so that
others can move the worksheets into their workbooks without having to
import/export a VBA module.

Barring rules of thumb, is it possible?





Norman Jones wrote:
Hi Floyd,

Why would you want to put a udf in a sheet module?

As a rule of thimb, use the worksheet module only for worksheet event
code.



---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
All:

Is it possible to use UDFs in a worksheet's code section? If so, how?

I can't seem to get the functions to calculate when called from a
worksheet.

Thanks in advance.