View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default UDF doesn't work in old worksheets

Make sure you add in the addin
--
Gary's Student


"BartDesc" wrote:

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 InsertFunctionUser Defined.
When I go tho VBA editor the xla is there.

What do I do?

THanks