Will user defined functions in MS Excel be lost while transferring the file to another user/computer?

You need to ensure that the macro for the UDF resides in the same workbook. I store mine as part of a module in the Visual Basic Editor. If you do that, it will be transferred with the file guaranteed.

User defined functions are macros, so they must run when the user computer security level is medium or low (Concern that)

That was issue number 1

Issue number 2 will be the pathes for these files, the end-user must put them all in the same folder, (not only same folder) but also in the same path.

Means if your files were in C:\Work1 folder, the end-user must put them also in C:\work1 folder.

The function itself can be called frm any file (once the file with the UDF is opened), but the links will have some diffeculties in linking values

I worked alot with these issues.

So if you have only UDFs in one file and made sure that the user will open it, it will be no problem, but the links between cell values may face this issue.

I can help you here if you are interesting and show you how to manage these, mail me here

Enjoy my profile, I am the VBAXLMan

If you can, save 1 file with all of the worksheet contained within it.

Save a copy of your file with the User Defined Functions as an add-in file type (*.xla), then have them load it as (Tools > Add-Ins...)

If they don't have your User Defined Function they cannot use it.

Send them the *.xls and the *.xla file.

Yes the udf will be lost you have to send the addin also along with it to get it work.

Makarand

I guess the function wont be affected as they are embedded in the file . U can send a me a email and let me check it out and let u know my email id is neadvantage@gmail.com .

No, they will not be lost.