UDF doesn't work in old worksheets

[Guest]

Hi,
I had different workbooks all with the UDF "Calculate".
I learned about xla and thought it would be nice to put the function in an
xla in the XLstart folder.
On a new workbook the function works fine. But on the orginal (where I
deleted the Calculate Function) I get the #NAME? error.
The only difference I could find is that a new workbook has the xla listed
in the links. In the old workbook Links is grayed out in the Edit menu, so
there are no links available.

Is this Normal?

In both files the function is listed under Insert>Function>User Defined.
When I go tho VBA editor the xla is there.

What do I do?

THanks

 

[Guest]

Make sure you add in the addin

 

[Guest]

THanks
It doesn't help.
Reading around I thought that was normally not necessary, as it is
automaticcaly loaded when it's in XLstart.
Even more: in the newer workbooks it isn't listed as an addin and it does
work.
Even more: In other older workbooks I don't have the problem: just those
which previously had the function (which that I deleted, when the function
was placed in xla file).
Bart

 

[Dave Peterson]

Saved from a previous post for the same kind of problem--the UDF was in a
workbook, then moved to an Addin.

After I moved the code from one workbook's project to the other and saved both
files (one as an addin), I did this in the "regular" workbook (.xls) (with the
..xla still open).

Insert|Name|define
myFunc
(refer to any cell)
Add

Then I deleted that name.
insert|name|define
myfunc
delete

Then I did edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Excel was smart enough to reevaluate this function from the xla.


========
myFunc will be the name of your UDF.