how to move user defined function
 

I created a function and stored it in personal.xls. Function works fine. When
I reopen the spreadsheet on a different pc, it can't find the function. I
have the same personal.xls copied to all of the machines.

I would like to copy this function from the personal.xls to the spreadsheet
that I am working on so that it stays with the spreadsheet.

Hi Grant,
What is stopping you doing the copy?
Use Window|Unhide to see Personal.xls; open VBA editor and copy the function
code
Open the workbook in question; open VBA editor; Insert - Macro and copy the
code

Another way is in Personal to use Export and in other book to use Import (of
Basic file)

Come back with questions when you have tried.
best wishes
Bernard

"Grant" wrote in message
...
I created a function and stored it in personal.xls. Function works fine.
When
I reopen the spreadsheet on a different pc, it can't find the function. I
have the same personal.xls copied to all of the machines.

I would like to copy this function from the personal.xls to the
spreadsheet
that I am working on so that it stays with the spreadsheet.