User defined function
 

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

User defined function
 

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.
--
HTH...

Jim Thomlinson


"David" wrote:

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

User defined function
 

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


"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"David" wrote:

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