Hi!

I'm getting a strange behaviour which I would like to know how to
workaround.

New Workbook
Add a module
New Function:
Public Function MyTest(abc As String) As String
MyTest = "Hello!"
End Function

ThisWorkbook.AddIn = True
Save the Workbook as C:\MyAddIn.xla
Close Excel
Open Excel
Tools | Addins | Browse for MyAddIn.xla

New Workbook
In A1:
=MyTest("Greetings")
(A1 should now have a value of Hello!
Save this Workbook as C:\Book1.xls
Close Excel
Open C:\Book1.xls

The Formula in A1 now reads:
=MyAddIn.xla!MyTest("Greetings")


How can I make it never put a qualifier in front, like XLLs behave?


A second question.
Now that I'm using the UDF from the xla, an entry shows up under Edit |
Links.
If I move Book1.xls to another drive letter, then the link breaks.


Any solutions would be gratefully accepted.


Rob