hjyoungii wrote...
I created a spreadsheet for someone that contains user defined functions.
However, when I sent him the spreadsheet, the functions are not available.
How do I get them to him?
Do you mean the formulas using your udfs return #NAME? errors when this
other person uses your workbook? If so, udfs are considered the same as
macros by Excel macro security. If this user has macro security set to
High or Medium and chooses not to activate macros in your workbook,
then it will seem as if your udfs do not exist.
What is your user's macro security setting? What formula results is
this user seeing? When your user opens your workbook, does Excel
display a dialog stating that it has disabled macros or prompting the
user to enable or disable macros? If the latter, is the user enabling
or disabling macros?