View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Howard Howard is offline
external usenet poster
 
Posts: 3
Default saving as an add-in?

I've written some functions at work and saved the workbook as an add-in.

Another workbook that used this add-in worked fine at work but not when
I brought it home (presumably as the add-in was not on my home machine)

So I copied the text of the functions, put them in a new workbook at
home and saved that as an add-in at home.

At first the workbook that used the add-in functions would not re-calc
at home so I used the add-in manager to install my add-in but then it
required me to re-enter all of the user defined function calls in the
cells as they displayed a path to the add-in on my work machine. I guess
that I'll also have to repeat this in reverse when I take it back to work.

How do I get the functions in this add-in to work smoothly between
locations?

Howard