Where is User Defined FUnction

[KIM W]

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.

 

[Gary Keramidas]

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

 

[Dave Peterson]

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]

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.