| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dcount function within user-defined worksheet function | Excel Programming | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Hybrid Mode
