User defined function

[David]

Hi Group,

I have several User Defined Functions, but they were created years ago. I an
not find what file they reside in anymore. There is not a persoanl.xls in the
startup menu, which is where I thought it would be.

Any ideas in trying to figure out where they are? I have tried a search
using one of the Functions names "HTLMConvert" with no luck. I would like to
find out where these reside.

Thanks,
David

 

[Jim Thomlinson]

Assuming that these functions are not workbook specific then my best guess
would be that they are in an addin. When you open the VBE you will get a
listing of all of the open workbooks and addins.

 

[David]

Hi Jim,

I went to the VBE and took a look and do not see anything. I used the add-in
manger and found nothing there. I do get a list when I go to the Function
Insert f* and these seem to be available all of the time.

They must come from some file, yes? Is there a way from the f* to ID their
source? I could not see a way and I do not know how many files I have, but
many.

The list I get is:
Accrint
CopyFileTemplate
GetDivID
HTMLConvert
IsShared

Thanks,
David