Where is User Defined FUnction
 

I obtained an Excel 2007 Workbook that has a User Defined FUnction in it, but
I cannot locate the code for it. I am faily sure it is a UDF, and it works
properly. (It is called WSName and it displays worksheet name in a cell by
typing in =WSName.)
How can I find the code behind the UDF? I have searched around in various
modules to no avail.

Where is User Defined FUnction
 

udf's are in standard module. in vba, control-f to bring up the find dialog,
select current project and search for wsname

--

Gary
Excel 2003


"KIM W" wrote in message
...
I obtained an Excel 2007 Workbook that has a User Defined FUnction in it,
but
I cannot locate the code for it. I am faily sure it is a UDF, and it
works
properly. (It is called WSName and it displays worksheet name in a cell
by
typing in =WSName.)
How can I find the code behind the UDF? I have searched around in various
modules to no avail.

Where is User Defined FUnction
 

If you really type in: =wsname
and not =wsname() (with the ()'s), then it's not a UDF.

Look in the name manager for a defined name.



KIM W wrote:

I obtained an Excel 2007 Workbook that has a User Defined FUnction in it, but
I cannot locate the code for it. I am faily sure it is a UDF, and it works
properly. (It is called WSName and it displays worksheet name in a cell by
typing in =WSName.)
How can I find the code behind the UDF? I have searched around in various
modules to no avail.

--

Dave Peterson

Where is User Defined FUnction
 

I really should be using pseudoname for my posts here! I overlooked the
absence of parentheses, and therefore missed that it could be a named formula
(which it was.)
BTW, here is what it was, returning name of worksheet:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)

Thanks.

"Dave Peterson" wrote:

If you really type in: =wsname
and not =wsname() (with the ()'s), then it's not a UDF.

Look in the name manager for a defined name.



KIM W wrote:

I obtained an Excel 2007 Workbook that has a User Defined FUnction in it, but
I cannot locate the code for it. I am faily sure it is a UDF, and it works
properly. (It is called WSName and it displays worksheet name in a cell by
typing in =WSName.)
How can I find the code behind the UDF? I have searched around in various
modules to no avail.

--

Dave Peterson