Never show User Defined Function Qualifier

  • Thread starter Thread starter Rob van Gelder
  • Start date Start date
R

Rob van Gelder

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
 
I get the same result for the fiorst part, ie th ecell
shows

=MyAddIn.xla!MyTest("Greetings")

BUT when I recalc this becomes
=MyTest("Greetings")

The link should not break if you simply save or move the
active workbook into a new location. It should only break
if you move the xla

Parick Molloy
Mitcrosoft Excel MVP
 
Back
Top