Will user defined functions in MS Excel be lost while transferring the file to another user/computer?
I am creating a group of 4 MS Excel files located at the same location, that are inter-linked and contain several user-defined functions (UDFs). If I email these files to another user, will they be able to view the data as it should be (considering they place all the files in on location on their PC)?
Or will the user-defined functions I created be lost, causing the data to be erraneous?
Renaud2006-12-21T09:16:29Z
Favorite Answer
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
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 .