User Defined Addin - Urgent Please Help!
Kirit,
Usually, if the add-in is still open, you should have no trouble. But
you can try setting a reference to the add-in before you save the
file, using Tools | References ...
HTH,
Bernie
MS Excel MVP
"Kirit Patel" wrote in message
...
I have a addin that i have created using Excel 2000.
Within this addin, there is a user defined function, it
returns a value.
Let us assume the addin is in C:\MyAddin. I then open
this addin. From a blank spreadsheet, i call the user
defined funtion (Insert Function). I then save this
spreadsheet in another directory c:\MyReport. If i shut
the report down and re-open is from c:\MyReport, i get
prompted to re-establish links. How can i avoid this
problem. It only seems to work if the my custom addin and
report reside in the same directory.
Please Help!!!!
|