external Excel Add-In reference

[excel newbie]

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.

 

[Gord Dibben]

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.

File>Save As>File Type>MS 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

 

[excel newbie]

thanks, i will post the xla in the network folder and see if that addresses
the issue. i am assuming the folder you are referring to is the same floder
where is saved the spreadsheet
vba newbie

 

[excel newbie]

i tried doesn;t work, i must not have made my question clear. i did all the
steps you discussed and the addin work just fine on my computer. the problem
happens when other people have the add-in in computer directories. but when
they try to use the same spreadsheet i was using, the speadsheet does work
even though the addin is in thier excel, instead the speadsheet has external
links back to my computer for the addin.