Embed a function
 

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

Embed a function
 

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