View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Problem with user functions in Add-ins for multiple persons

Addins can be stored wherever you like and so just choose a location.

If you want to simplify this, just store them on a network share and
have everyone use the same one[s]. It will be necessary, though, to
choose *NO* when asked if you want to copy the addin to the local
machine. Of course, you will have to delete/move these from the local
folder so next time you open the AddinsManager Excel will ask you if
you want to remove them from its list. Be sure to tell Excel to delete
it, then close the dialog, then close Excel. When you reopen Excel and
the AddinManager, add the file[s] on the network share one at a time
without copying to the local machine.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion