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
|