I have written a custom function. It works perfectly well when the cod
is in a module sheet in the same workbook that the function is use
in.

However, when I create an AddIn file for this custom function by savin
it as an AddIn i.e with an .xla extension, e.g MyFunc.xla and then us
the function in another workbook, it always comes up with an error
Before using this function in the other workbook, I have made sure tha
with the workbook that I want to use the function in as the activ
workbook, a reference to the addin (MyFunc.xla) has been made b
checking the check box for this addin by going into Tools-Addin etc..

What am I doing wrong? Can anyone help?


Best regards


Deepak Agarwa

--
Message posted from http://www.ExcelForum.com