You cannot change a function into an add-in nor can you put an add-in into a
"worksheet" nor can you put a "worksheet" on the network.

Functions live inside modules in a workbook which can be a regular workbook or
an add-in.

The proper and only method is create a workbook with the macros and functions in
modules then save that workbook as an Addin.

FileSave AsFile TypeMS Excel Add-in(*.xla)

You then post that add-in to the network folder.


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 11:08:01 -0800, excel newbie <excel
wrote:

i wrote an excel function and changed it to an add-in and put into a
worksheet and put the worksheet on the network. other users have added the
add-in to thier excel. However, when they open the worksheet with the custom
add-in, they get an external reference pointing back to the orginal computer.
and the add-in is not functional. how do i correct this?

if i am in the wrong forum please advise this newbie.