Hi;

I have a user-defined function I've written and stored in
a .xla file. So, I have this function available to any
open workbook. Works great, except when I email the
spreadsheet to someone else, it asks them about the link
and you know the rest.

How can I "embed" this function into all my
spreadsheets?? Would I have to write a macro that copies
and pastes the code into the current spreadsheet?

Thanks for your help

You would either need to supply the addin or, as you say, place the function
in the workbook you are emailing.

--
Regards,
Tom Ogilvy

"Julie" wrote in message
...
Hi;

I have a user-defined function I've written and stored in
a .xla file. So, I have this function available to any
open workbook. Works great, except when I email the
spreadsheet to someone else, it asks them about the link
and you know the rest.

How can I "embed" this function into all my
spreadsheets?? Would I have to write a macro that copies
and pastes the code into the current spreadsheet?

Thanks for your help